Monitoring Sql Server2000...............
-
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
-
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
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