• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1643
  • Last Modified:

SQL 2005 Multi processor utilisation. How to check and enable all processors and prcoesse are being used by SQL 2005

Hi We have a Dell Poweredge 2950 with Dual Quad core processors.  We have installed SQL 2005 and would like to check to ensure that all the processors and processes are bring used by SQL.  How can we check this and if not how can we enable SQL to access the additional processing power.

Thanks

Potts2002
0
Potts2002
Asked:
Potts2002
  • 3
  • 2
1 Solution
 
imran_fastCommented:
Right click sql server in management studio click properties
check processors
0
 
Potts2002Author Commented:
Hi Imran

I have checked that and it lists processors 0 - 7 and all are ticked.  Presumably that signifies that SQL is using all the processors!!
Is there anything else we need to check?
Is there any utility/process we can run which will indicated how fast SQL is running?
0
 
imran_fastCommented:
it that is the database server than you need to monitor the following performance counters
Performance Audit Checklist
 Counter Name       Bottleneck if Counter
 Memory: Pages/sec       Average less than 20
 Memory: Available Bytes       Average <5MB
 Physical Disk: % Disk time      Greater then 55 for 10 Min period
 Physical Disk: Avg. Disk Queue Length       Greater than equal 2 for 10 Min Period
 Processor: % Processor Time       exceeds 80% for continuous periods
 System: Processor Queue Length       exceeds 2 per CPU for continuous periods
 SQL Server Buffer: Buffer Cache Hit Ratio       should exceed 90%, and ideally be over 99%
 SQL Server General: User Connections       connections exceeds the number of available worker threads, then SQL Server will begin to share worker threads
0
 
Potts2002Author Commented:
Hi Thanks Imran.

We have checked all the monitors and everything is OK.

We have a particular app which is running slow but is also not challenging the performance of the server can you suggest any other config areas to check?

Thanks

Potts2002
0
 
imran_fastCommented:
How much memory you have allocated for your sql server by default it takes only 4 GB if you want to increase that then look for this article
http://exact.nl/docs/BDDocument.asp?Action=View&ID=%7BD249749C-BF41-458C-9969-E0F8F2F72077%7D

also run sql profiler to grab long running quries and then use sql engine tuning advisor to look for suggestions.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now