on 11-27-2006 9:37 AM
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
Hi,
Check in Enterprise Manager \ <database> \ Management \ Current Activity \ Proces Info.
Maby there is any dead process with high CPU utilisation.
Regards,
Marcin Gajewski
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.