July 27, 2010 at 2:16 pm
Hi all,
I was wondering what are some tools and metrics you use to measure your SQL server performance. Do you use things like perfmon, profiler, and if so, how or perhaps 3rd party tools.
I need to find some concrete figures to measure the load on our current servers to see if perhaps it would be a good idea to virtualize or maybe consolidate them. I'm new to server performance.
Thanks.
July 27, 2010 at 5:50 pm
For what you are looking at, I use perfmon to capture the server stats and i have a job that runs once a month to capture actual MDF/LDF/NDF growth on all partition and job. Any time we spec out new server or think of consolidating, we take the data for the last 2-5 years depending upon how long the database has been around and actually calculate a running month increase in performance. This give us the ability to see if there is a trend upward or downwards on the server for growth and what need to happen for our planning.
Fraggle.
July 27, 2010 at 6:18 pm
Here are some resources for that
and
http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/
and
http://sqlserverpedia.com/blog/category/sql-server-performance-tuning/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply