Jack Corbett (11/11/2005)
I liked the article as it was concise and gave good tips for where to start. Is anyone out there using the SQLH2 tool available from MIcrosoft. I am using it and it is very helpful as it provides reports (SQL RS) that allow you to track usage over time. It is not as user friendly as some other tools available from Idera and others, but it is free, which at my compnay makes it the only one I can use to monitor.
has to be free - sounds very familiar! Are you using SQLH2 to monitor performance in a simliar fashion to the performance counters? I going to download it but is there any advice on using it that could be helpful?
Also a general question to all - I'm not a DBA by trade, but I do have to look at performance issues and maintain SQL server instances, so how and where are you storing the results on performance monitoring? Are you doing this constantly, at set times during the day etc etc.? Also, what are you using to compare baseline readings.
With a background in BI work - I'm curious as whether I can use BI to help trend and analyse performance counters across servers. Has anyone else done this?
Good article though that has pointed me in the right direction.
MCITP: Business Intelligence Developer (2005)