June 30, 2010 at 2:39 am
Hello,
1. What is the difference between SS2008 and SS2K8 R2? Are there any additional features which will affect end user running queries on the database through a desktop / web application?
2. We have a server upgraded from SQL Server 2K to SS2K8. The CPU usage is usually 50%+ without any user connections. What could be the reason?
Thanks in advance.
Regards,
Rohit
June 30, 2010 at 2:53 am
Rohit Chitre-274613 (6/30/2010)
1. What is the difference between SS2008 and SS2K8 R2? Are there any additional features which will affect end user running queries on the database through a desktop / web application?
Google 'SQL 2008 R2 features'. Mostly BI-related features
2. We have a server upgraded from SQL Server 2K to SS2K8. The CPU usage is usually 50%+ without any user connections. What could be the reason?
Is it SQL using that CPU? If so, check what it's running (sys.dm_exec_requests or profiler)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2010 at 4:53 am
Thank for the reply.
It is BROKER_TRANSMITTER which has maximum wait_time. Can this be optimised / disabled?
Regards,
Rohit
June 30, 2010 at 7:13 am
The broker-related processes are supposed to be waiting most of the time. They're idle the vast majority of the time waiting for something to do. They should have high wait times, if they didn't I'd be worried.
Waiting != using CPU. Look for what's using CPU (high CPU times relative to login time), after checking that it really is SQL using that CPU, not some other process.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply