Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am in the process of identifying the most active databases on the server and will be moving the databases off the current server to alleviate the load.

The reason to do it is that our servers are hosting databases for out clients (per client 3 databases - 1 Main, 1 Archive and 1 for Login authentication).

I need to find out what databases are used most interms of CPU, Memory and Disk I/O.

What is the best efficient way of doing it ?

What I have tried :

Look at the buffer pool usage :

My questions are :

  1. Am I in the right direction ? What other things I can consider, so that moving the databases off from this server will alleviate the load on the server.
  2. How do I tie up menory usage, CPU and disk latency in figuring out the right database to move off the server ?

Any thoughts/suggestions are highly appreciated.

Below are the specs:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7600: )

3 sql server instances running

98 GB total physical memory. Max memory is 29GB per instance

Logshipping running every min for Main database and every 15 mins for Archive and Authentication databases.

share|improve this question
    
I assume there's some crazy reason you're stuck on RTM since SP2 has been available since July 2012 –  billinkc Oct 31 '13 at 16:28
    
@billinkc yes .. We are looking into patching with SP2 or the latest one and I have raised this many times but you know how difficult is to go through change management. –  Kin Oct 31 '13 at 16:33
    
does this answer help at all? i'd be happy to elaborate on this stuff if you need something different. –  swasheck Nov 5 '13 at 16:29

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.