Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 108
  • Last Modified:

10774: generate a baseline

Hi Experts:
I need to generate a baseline before initiating corrective action on some querys on the database. I need some reference to compare and see how we've improved.

I need to consider the following aspects:
Measure the current consumption of resources by SQL Server.
Measuring how various workload of SQL Server in time.
Monitor peak consumption to avoid rework.

It is possible to generate the baseline, running SQL dynamic view "sys.dm_"
0
enrique_aeo
Asked:
enrique_aeo
  • 3
  • 2
2 Solutions
 
Scott PletcherSenior DBACommented:
Yes.
0
 
enrique_aeoAuthor Commented:
Example Please
0
 
enrique_aeoAuthor Commented:
Please experts:

Any URL where it appears as these views can work together
sys.dm_exec_sessions
sys.dm_os_schedulers
sys.dm_tran_locks
sys.dm_io_virtual_file_stats
sys.dm_db_index_physical_stats
sys.dm_os_performance_counters
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
What about saving Performance Counters for a working period and set that as baseline?
In the future you can compare it with actual Performance Counters.
0
 
enrique_aeoAuthor Commented:
can you explain me with this dinamyc view
sys.dm_exec_sessions
sys.dm_os_schedulers
sys.dm_tran_locks
sys.dm_io_virtual_file_stats
sys.dm_db_index_physical_stats
sys.dm_os_performance_counters
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I was talking about Performance Counters but I can see you have already your mind set on those dmv's and for that you can get a snapshot running the following command:
SELECT GETDATE(), * FROM sys.dm_os_performance_counters
SELECT GETDATE(), * FROM sys.dm_db_index_physical_stats(null, null, null, null, null)
SELECT GETDATE(), * FROM sys.dm_io_virtual_file_stats(null, null)
SELECT GETDATE(), * FROM sys.dm_os_schedulers
SELECT GETDATE(), * FROM sys.dm_tran_locks
SELECT GETDATE(), * FROM sys.dm_exec_sessions

Open in new window

But don't forget this is only a snapshot that's why I added the GETDATE() so you can record the date and time for each snapshot that you want to take. You can even create a job and schedule it to run every 15 minutes. It's just an example and you need to set the schedule period as you need.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now