November 6, 2013 at 11:25 am
Can someone please share the scripts to find out the most and least utilized databases?
I'll be monitoring them for a month to decide which of the SQL 2000 databases need to moved to SQL 2008 R2.
November 6, 2013 at 1:01 pm
It really depends on what you consider to be "utilized". Does that mean resources, i.e. CPU, memory, I/O, etc? Does it mean user connections, batches/sec, etc? Does it mean data growth?
There is no one correct answer and you will have to determine what you want to measure before you starting looking for a tool or set of scripts.
November 6, 2013 at 1:09 pm
Keith Tate (11/6/2013)
It really depends on what you consider to be "utilized". Does that mean resources, i.e. CPU, memory, I/O, etc? Does it mean user connections, batches/sec, etc? Does it mean data growth?There is no one correct answer and you will have to determine what you want to measure before you starting looking for a tool or set of scripts.
My bad. I just want to check how frequently are the tables of each sql 2000 database accessed.
November 6, 2013 at 1:51 pm
You may want to set up a simple profiler trace with just the RPC Completed, and T-SQL completed events being monitored. Run that for a while, then save the output to a table. You can do all sorts of analysis on the table. How many commands run per database, how many CPU ticks (roughly) per database, etc..
November 6, 2013 at 2:17 pm
Matt Crowley (11/6/2013)
You may want to set up a simple profiler trace with just the RPC Completed, and T-SQL completed events being monitored. Run that for a while, then save the output to a table. You can do all sorts of analysis on the table. How many commands run per database, how many CPU ticks (roughly) per database, etc..
If this is a production machine make sure you run it as a server side trace. http://technet.microsoft.com/en-us/library/cc293613.aspx
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply