Comments
Sort by recent activity
Hi Jalfano,
SQL Monitor will use CPU resources in proportion to the number of monitored entities (and their complexity). It does a fair bit of work per entity so what you're seeing is to be expected for a reasonable deployment (15+ machines, many SQLs, many databases).
I'll have a look at the profiler trace.
How many machines are you monitoring and how roughly many databases are being hosted on them?
Regards, / comments
Hi Jalfano,
SQL Monitor will use CPU resources in proportion to the number of monitored entities (and their complexity). It does a fair bit of work per entity so what you're seeing is to be expecte...
Hi,
To monitor 30 servers you will need a dedicated machine with more than one core.
A test server of mine has 23 machines, 39 SQL instances and uses about 85% of an Intel Core2 Duo 2.66GHz.
I suspect that your test deployment is working as intended given a single core and the desired work load.
Sql Monitor logs its behaviour during operation (Documents and Settings\All Users\Application Data\Red Gate\Logs\SQL Monitor 2 on XP or in ProgramData on Vista/Win7/2008). If there is a problem with the deployment, you may see errors in the logs (they'll be full of informational messages, but errors will be searchable with the word 'error').
Regards, / comments
Hi,
To monitor 30 servers you will need a dedicated machine with more than one core.
A test server of mine has 23 machines, 39 SQL instances and uses about 85% of an Intel Core2 Duo 2.66GHz.
I susp...
Hi,
If you download Sql Monitor from the products page on the main website, you'll get version 2.1.
2.1 is also in the Sql Toolbelt, though that is a larger download.
Regards, / comments
Hi,
If you download Sql Monitor from the products page on the main website, you'll get version 2.1.
2.1 is also in the Sql Toolbelt, though that is a larger download.
Regards,
Sql Monitor will check for updates and place a thin banner at the top of the web page if it finds a more recent copy. Clicking on this will take you to a web page detailing the update.
We activate this feature a week or so after releasing the update through the website and support. / comments
Sql Monitor will check for updates and place a thin banner at the top of the web page if it finds a more recent copy. Clicking on this will take you to a web page detailing the update.
We activate ...
Hi,
Regarding the choice of web interface, you're right that you can just VPN in and fire up a traditional winforms app. However, this isn't possible on mobile devices and it's a hassle to do from a new location.
Also, you can email someone the URL from Sql Monitor and they can see exactly what you're seeing without having to install any client (we encode quite a lot in the URL). The email alerts can also link directly to the alert details.
Regards, / comments
Hi,
Regarding the choice of web interface, you're right that you can just VPN in and fire up a traditional winforms app. However, this isn't possible on mobile devices and it's a hassle to do from ...
Hi,
Thanks for the further info. The width behaviour of the viewer has been changed and SQL 2000 related trace issues are presently being improved. Both fixes will be in 2.1 when it goes out (TBA).
Regards, / comments
Hi,
Thanks for the further info. The width behaviour of the viewer has been changed and SQL 2000 related trace issues are presently being improved. Both fixes will be in 2.1 when it goes out (TBA)....
Hi xexex,
Thanks for the feedback. I don't know why the trace data isn't being appended to the alert - I'll move some test effort on to this area. As for the truncated fragment, I'll put the relevant developer on the issue and hopefully this will be improved for 2.1.
Thanks, / comments
Hi xexex,
Thanks for the feedback. I don't know why the trace data isn't being appended to the alert - I'll move some test effort on to this area. As for the truncated fragment, I'll put the releva...
To upload an image, use imageshack.us and paste the link into your reply like this: [image] / comments
To upload an image, use imageshack.us and paste the link into your reply like this:
Hi,
Activating trace only affects alerts generated from that point onwards; old alerts can't be updated as trace is not retroactive. Additionally, there is a small delay (0~15 seconds) from when the alert is first generated to when trace data is attached.
Are you finding that new alerts are not being tagged with trace data?
Regards, / comments
Hi,
Activating trace only affects alerts generated from that point onwards; old alerts can't be updated as trace is not retroactive. Additionally, there is a small delay (0~15 seconds) from when th...
Hi,
Sometimes this is just the first word or entire block of SQL. This information is taken as-is from SQL Server. However, if you enable trace (small performance hit on the server you're monitoring, so do this only when debugging an active issue) you can view full SQL transcripts. In the alert details, open the SQL Process / profile trace tab and click on a process to display the captured trace.
Hope this helps, / comments
Hi,
Sometimes this is just the first word or entire block of SQL. This information is taken as-is from SQL Server. However, if you enable trace (small performance hit on the server you're monitorin...