cancel
Showing results for 
Search instead for 
Did you mean: 

SQL database...busy....what's it doing?!?

Former Member
0 Kudos

Today a R/3 sap system is very low in performance. We have checked on the TASK MANAGER and we have seen that it's due to a high use of CPU by SQL DATABASE. So....cause we don't have activate any strange activity on it we would like to monitor which activity is running on it?how can we see that?

thanx very much

Sonya

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Check in Enterprise Manager \ <database> \ Management \ Current Activity \ Proces Info.

Maby there is any dead process with high CPU utilisation.

Regards,

Marcin Gajewski

Answers (1)

Answers (1)

clas_hortien
Active Contributor
0 Kudos

Hello,

you can use the SQL Profiler to see all activity running on the SQL Server. The Profiler will capture any single command issued to the SQL Server, but might have a performance impact.

Furthermore can you check the activity with the activity monitor (SQL 2005) or with the Enterprise Manager -> Management -> Current Activity -> Process Info. There you will see all connections made to the SQL Server and what it is currently doing (doubleklick on it).

Best regards

Clas

Former Member
0 Kudos

Oh thanx very much for your useful answers I've left a feedback

Kisses SONYA!!!