User profile for lewismoten

Thanks Nigel. I was seeing the same problems with 46 occurrences in the last hour alone. This may be a useful bit of information in the help file, or perhaps to add an alert/recommendation that the log file is getting to be too long. / comments

Thanks Nigel. I was seeing the same problems with 46 occurrences in the last hour alone. This may be a useful bit of information in the help file, or perhaps to add an alert/recommendation that the...

0 votes

I don't see the error in the client anymore, but looking through some of the logs, i do see a few stack traces being written out. I am forwarding them along to your email. / comments

I don't see the error in the client anymore, but looking through some of the logs, i do see a few stack traces being written out. I am forwarding them along to your email.

0 votes

I am no longer seeing this after this past weekend. / comments

I am no longer seeing this after this past weekend.

0 votes

Does each person using SQL Alert client need to also license each server, or are the servers licensed with the repository itself that the clients connect to? / comments

Does each person using SQL Alert client need to also license each server, or are the servers licensed with the repository itself that the clients connect to?

0 votes

Thank you. I'm glad to see the new features for cpu utilization have been added. They will surely help identifying what exactly is utilizing all of that CPU power. Regarding the alerts, I was aware of them and had actually been able to test them (just left the cleanup jobs for my backup plan to stop running). I didn't test the server down yet, but I did see an alert for it in the templates. / comments

Thank you. I'm glad to see the new features for cpu utilization have been added. They will surely help identifying what exactly is utilizing all of that CPU power. Regarding the alerts, I was aware...

0 votes

At the moment, I'm still trying to tweak my maintenance plans to get the recommendations out of my hair. Once that is taken care of, I'll propagate the same plans to the other servers. In that sense, SQL Response really isn't necessary to monitor the recommendations for the other servers since one servers setup can pretty much be assumed to be valid for the others. The thing I find most important though is the actual alerts monitoring downtime, long queries, job problems, etc. Given the price, I may have to start out with the most critical servers and wait for the tool to prove its worth before obtaining more licenses. Once the product comes out of beta, I can put together a few proposals to send over to management to list different options we can go for - critical only, critical + development servers, the whole office, or the whole office plus a few reserve licenses. Is their also a site license to cover unlimited servers in the same office? New servers come online often, so it would be a hassle to keep asking for new licenses each time one comes online. I'm having difficulty understanding the CPU utilization unusual messages. They seem to always occur when backing up databases, checking integrity, defragging, or out in the blue, etc. Just one instance (out of four on one server) has 120 databases on it that takes roughly 30 - 45 minutes to do a full backup, so I can understand the CPU usage, but is it complaining that a portion of the backup process is heavy CPU (10 seconds), or the whole backup process? Is this directly related to backups, or is something else going on in addition? None of the system processes listed show how much CPU/memory they were using at the time either, so I don't know if it is SQL Server, or another system process that is the culprit here. Maybe a virus checker is scanning a file backup as it is being made. I just don't know. The main thing that is critical to me is knowing that a hard drive will soon run out of space, or that the server is down. As long as the database server responds to queries, I am not in the hot seat getting unpleasant phone calls. However, I can work on understanding why performance is bad and perhaps improve the speed of the server when an alert is raised. / comments

At the moment, I'm still trying to tweak my maintenance plans to get the recommendations out of my hair. Once that is taken care of, I'll propagate the same plans to the other servers. In that sens...

0 votes

Ok, thanks. I manage 63 instances (36 machines in all here), but I doubt I be able to talk management into monitoring them all depending on the final price. / comments

Ok, thanks. I manage 63 instances (36 machines in all here), but I doubt I be able to talk management into monitoring them all depending on the final price.

0 votes

We have TFS 2005, but the pending changeset only shows options to create working folders for VSS and VSS (Internet). I tried entering TFS for the url with the Internet version of VSS, but it wouldn't accept a local path for my working folder. / comments

We have TFS 2005, but the pending changeset only shows options to create working folders for VSS and VSS (Internet). I tried entering TFS for the url with the Internet version of VSS, but it wouldn...

0 votes

I agree with a longer trial period for beta products. Since the beta expired, I've been hunting the internet for a similar tool. If the beta lasted until the release, I wouldn't be looking for a competitors product. :? / comments

I agree with a longer trial period for beta products. Since the beta expired, I've been hunting the internet for a similar tool. If the beta lasted until the release, I wouldn't be looking for a ...

0 votes

As I mentioned, I get this when opening a database node. It would be nice to see these errors logged in the event viewer. [image] SQL Dependency Tracker - Beta has encountered an unexpected condition. :shock: Object reference not set to an instance of an object. NullReferenceException [image] at _5.PrepareBusy(Object state) :x at _129._1(_4 , Object , _130 ) at _5._1(Control ) at _2._1(TreeListNode , TreeListColumn ) at _2._5(Object , EventArgs ) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) / comments

As I mentioned, I get this when opening a database node. It would be nice to see these errors logged in the event viewer. SQL Dependency Tracker - Beta has encountered an unexpected condition. ...

0 votes

How can we help you today?

lewismoten

Comments