Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Monitoring question Expand / Collapse
Author
Message
Posted Wednesday, November 6, 2013 11:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 9:35 PM
Points: 298, Visits: 1,100
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.
Post #1511966
Posted Wednesday, November 6, 2013 1:01 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 4:29 PM
Points: 588, Visits: 900
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.




Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1511987
Posted Wednesday, November 6, 2013 1:09 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 9:35 PM
Points: 298, Visits: 1,100
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.
Post #1511989
Posted Wednesday, November 6, 2013 1:51 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 10:20 AM
Points: 261, Visits: 469
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..
Post #1512001
Posted Wednesday, November 6, 2013 2:17 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 4:29 PM
Points: 588, Visits: 900
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




Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1512008
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse