0

I'm looking to schedule a resource heavy job on the database.
I'd like to see the historical load of the MSSQL server to determine a time slot.
Is there a way to do that?

David
  • 3,736
  • 8
  • 33
  • 52
  • Start recording: http://www.databasejournal.com/features/mssql/article.php/3932406/Top-10-SQL-Server-Counters-for-Monitoring-SQL-Server-Performance.htm – ta.speot.is Mar 04 '13 at 10:57

2 Answers2

0

There is DBCC MEMORYSTATUS to get a tons of memory information. you can also refer to previous SO to find the utilization.

Community
  • 1
  • 1
Travis G
  • 1,592
  • 1
  • 13
  • 18
0

A nice easy way to get the information that you want is to use a SQL Server feature called the data collector.

There is a nice step by step tutorial on how to set this up here:

SQL SERVER – Configure Management Data Collection in Quick Steps

You can also create your own data collectors so that you can persist DMV information (remember DMVs only show information since the last time SQL server was restarted).

steoleary
  • 8,968
  • 2
  • 33
  • 47