Monitoring Sql Server2000...............

• Papillon

  Hall of Fame

  Points: 3303

  More actions

  July 7, 2005 at 3:39 am

  #74939

  Hello guys!!

  What is the minimum time (in ms) required to respond from sql server when data is near @ 1.2 GB

  and also where i will get some kind of utility or sql command where i will find

  1. Check the space allocated to Database  

  2. Check the total space remaining in database  

  1. Check Memory Usage of MSSQL  

  2. Check CPU Utilization  

  3. Check Disk contention  

  1. Use SQL Server profiler  

  2. Check Trace event, lock event, session event etc  

  3. Create Trace  

  1 . Check for memory utilization  

  2. Check for unwanted process utilizing Memory  

  3. Check database memory utilization

  these factors

  T.I.A

  Shashank

    

   

  ---

  Regards,

  Papillon

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  July 7, 2005 at 6:12 am

  #571716

  Without intentionally making this sound stupid...  Have you checked BOL for any of this?

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• Papillon

  Hall of Fame

  Points: 3303

  More actions

  July 8, 2005 at 5:55 am

  #572249

  Hello

  thanks

  I checked it with on BOL and got query

  SELECT * FROM MASTER..SYSPROCESSES

  i got it just few more things i want to clear

  1) waittime

  2)cpu

  3)physical_io

  4)memusage

  what are units of these columns i.e waittime is in MS (miliseconds or else),

  like that cpu?,physical_io? and memusage (i.e in MB or else)

   

  T.I.A

  shashank

  ---

  Regards,

  Papillon