SQL Server Performance
-
We are planning to start performance monitoring of our SQL Servers. What are some excellent tools (internal or 3rd party) that could assist us with this tasks? Thanks!
Carpe diem! -
A lot.
You can check the overall cache hit ratio, processor, disk and RAM usage, number of connections, deadlocks, number of full scans, file size grow (or even worse file shrink) during operational time.
All this you can see in the performance monitor or some in the master..sysperfinfo table.
Also you can set your Profiler to check all the sql requests which have a duration more then let's say 5000 ms (or more or less it depends what kind of application you are running).
Once you have identified some poorly written queries and corrected them (by rewriting them or creating apropriate indexes) the overall performance could be better.
And itarete all them for ever. You know a DBA never can sleep too quite
Bye
Gabor -
I use DBArtisan from Embarcadero Technologies, and the latest version has new performance diagnostic tools that work well. They added new space and performance monitoring tools along with a historical tracking tool that tracks stats (waits, space, etc.) and allows you to do forecasting. Works for me.
I've also used the NetIQ stuff a little, but it didn't have enough meat for our servers.
-
Quest software has a few neat tools, like Spotlight. It's a newer product taht could be a little more robust but they promise that they will get there. Download the eval copy and try it out.
Terry -
Embarcadero also do something called Performance Centre, I have started to look into this but haven't got far yet. Spotlight seems ok, the downloaded eval version only gives a flavour as the drill downs from the GUI front end are disabled. You can't get the Embarcadero version without contacting a sales rep, I think this is because it may be a bit of a pig to setup and they don't want potential sales lost so they want to hand hold through the process.
I'm probably about to suggest we purchase DBArtisan with the 3 Analyst tools as an aid to daily management and firefighting. As too a 'performance and monitoring' solution, it seems to be down to NetIQ,Embarcadero or Quest, I'll being doing some further evals soon hopefully.
I was also looking for something to monitor jobs etc and found SQLSentry.com, however, it is only vapourware (well ok maybe beta) at present. Looks good though based on the words and screen shots.
Rick.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply