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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2004-05-26 : 08:15:01
|
| How to check whether the sql2k server is functioning at its best?I was asked by my management how i am sure that our production DB is funstioning at his best?Thank you.------------------------I think, therefore I am |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-05-26 : 08:23:10
|
| Just needs "another pair of eyes" to look over everything doesn't it?But keeping in mind, of course, that the more you spend on consultancy the more likely management are to believe the result ...Kristen |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-26 : 08:55:58
|
| Also, run Profiler or set up traces and write them to tables. Give them some reports that show them if you have things running slow, taking up a lot of reads, etc. Combine that with a report to show overall processor utilization, memory utilization, etc. They probably won't have a clue what they're looking at. It's good for you though to do this; and it will probably assure them you're on top of things.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Performance...