Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lazerath
Constraint Violating Yak Guru
343 Posts |
 Posted - 2005-10-24 : 17:02:25
|
| My manager has asked me to provide a report that profiles the performance of our SQL Server 2000 database server. I have used the Performance System Monitor and Profiler to troubleshoot and debug, but I've never had to compile the data into a non-techie readable format.A quick search on the web gives me a ridiculous number of third-party tools that we can't purchase until next year, so given only freeware, how can I best provide what my boss is requesting? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-24 : 17:16:04
|
| What kind of format is he looking for? Does he want to see graphs or just average numbes in Excel? PerfMon can be outputted into a csv file, which can then be easily opened into Excel. I'm not sure how your boss would even want to see Profiler data. Is he familiar enough with traces that he can just read the raw data?Tara |
 |
|
|
lazerath
Constraint Violating Yak Guru
343 Posts |
Posted - 2005-10-24 : 17:28:42
|
| No, unfortunately he comes from a project management background and really just wants to see the hot spots during a standard day of business.Thanks for the reply, I'll look into excel graphing. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-10-25 : 09:36:38
|
| A few things to look for in perfmon. If you can funnel the output to a database, you will be half way there (requires windows 2003).The basic resources for any server are CPU, Memory, and Disk.For CPU, collect %CPU Usage, and System:Processor Queue Length.For Memory, collect Pages/sec.For Disk, collect Avg. Disk Queue Length.The target values for each should beCPU %usage < 75%Processor Queue Length <= 2 * (number of processors in the box)Memory Pages/Sec. < 100Avg. Disk Queue Length <= 2 * (number of physical disks in the array)This is a very condensed version from SQL Server 2000 Performance Tuning. A fair book, if you are looking for tuning tips.EDIT: A graph, or numbers of how often you are in/out of compliance should be enough for the boss. Or you could do what I do and make up numbers. Not like they can check your work. (j/k) |
|
|
|
|
|
|
|
|
A Profile of System Performance