On Wed, Apr 15, 2009 at 10:59 AM, Matt Jarvis <[email protected]> wrote: > For those of you that to SQL Server DBA stuff, what sort of performance > monitoring tools do you use? -------------------------------------------
you need to benchmark your server to see where you are starting from. You then need to do a server reboot to see if your environment was hosed by another process. This is for data servers that are not just for data but for applications as well. You can find scripts for running a benchmark for 2000, I only have 2005 ones. You need to get a handle on jobs that are running and WHEN they run. You need to also define if queries are returning way too many rows. Last point is how your database was set up. Is this an fantastic OLAP design and your users are trying to do a lot of reporting off of it as well? If that is the case OLAP design is a terrible design for reporting. So you have to make a new DB for your reporting needs and feed it from the OLAP. Last is indexes, are they in the way? Does your system have a lot of inserts, or is it mild in inserts, and massive on queries and edits? -- Stephen Russell Sr. Production Systems Programmer Web and Windows Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
