How to find out what is the problem in SQL Server??
-
From last 5 to 6 days , our sql Server behaving ubnormally . CPU utilization goes to 100% , i stopped SQL Agent and Stopped DTC Service. but it did not help at all. CPU was remains at 100% . then i stopped SQL server. But after restarting ,CPU agians goes to 100%. I looked in the trace but i was not able to find any query or Stored Procedure which is taking the CPU cycles more than 1000 or 2000. I am not able to rectify the problem.. Kindly help me out.. thanks in advance .. i can provide some more details ,If any one needs it.
-
From last 5 to 6 days , our sql Server behaving ubnormally . CPU utilization goes to 100% , i stopped SQL Agent and Stopped DTC Service. but it did not help at all. CPU was remains at 100% . then i stopped SQL server. But after restarting ,CPU agians goes to 100%. I looked in the trace but i was not able to find any query or Stored Procedure which is taking the CPU cycles more than 1000 or 2000. I am not able to rectify the problem.. Kindly help me out.. thanks in advance .. i can provide some more details ,If any one needs it.
The easiest way to find out what's going on in SQL Server is to use Management Studio and open current activity. For more info: Monitoring with SQL Server Management Studio[^]
The need to optimize rises from a bad design.My articles[^]
-
The easiest way to find out what's going on in SQL Server is to use Management Studio and open current activity. For more info: Monitoring with SQL Server Management Studio[^]
The need to optimize rises from a bad design.My articles[^]
I am working on SQL server 2000 and i continuesly watching the Current activity in Process info option. i found same type of process with 60 to 70 number of simulatenously running activities. they all running the Sp_Cursoropen Command and consuming maximum CPU cycles. Example:- ProcessID ContextID User Database Status Command Application waittime CPU PhysicalIO MemeoryUsage 109 0 UApp Master Runnable Exec Sp_Cursoropen MicrosoftSQLServer 0 212810 23659 809 Kindly Help.. Looking for your Support.
-
I am working on SQL server 2000 and i continuesly watching the Current activity in Process info option. i found same type of process with 60 to 70 number of simulatenously running activities. they all running the Sp_Cursoropen Command and consuming maximum CPU cycles. Example:- ProcessID ContextID User Database Status Command Application waittime CPU PhysicalIO MemeoryUsage 109 0 UApp Master Runnable Exec Sp_Cursoropen MicrosoftSQLServer 0 212810 23659 809 Kindly Help.. Looking for your Support.