SQL Server 2008 uses half the CPU’s

Posted by ACALVETT on SQL Blogcasts See other posts from SQL Blogcasts or by ACALVETT
Published on Fri, 06 Jul 2012 19:20:00 GMT Indexed on 2012/07/06 21:21 UTC
Read the original article Hit count: 1296

Filed under:

Tips

|

Performance

|

Database Engine

|

2008

|

2008 R2

|

SQL 2008

|

cpu

|

Parallelism

|

Trouble Shooting

I recently got my hands on a couple of 4 socket servers with Intel E7-4870's (10 cores per cpu) and with hyper threading enabled that gave me 80 logical CPU's. The server has Windows 2008 R2 SP1 along with SQL 2008 (Currently we can not deploy SQL 2008 R2 for the application being hosted). When SQL Server started I noticed only 2 NUMA nodes were configured and 40 logical cores where there should have been 4 NUMA nodes and 80 logical cores (see below). The problem is caused by that fact that...(read more)

© SQL Blogcasts or respective owner

Related posts about Tips

3 Tips of SEO That Will Make You Money - Search Engine Optimization Tips

as seen on Ezine Articles - Search for 'Ezine Articles'
You need to make sure your marketing methods rank high in the Google and Yahoo search engines; to do this you're going to need to understand search engine optimization. Here are 3 SEO tips. >>> More
Tips for Managing Complex Queries

as seen on Internet.com - Search for 'Internet.com'
There are ways to structure a query that will minimize the complexity while raising confidence in the data returned. This article shares a few techniques that will help simplify the writing of complex queries. >>> More
Tips for Simplifying Crosstab Query Statements

as seen on Internet.com - Search for 'Internet.com'
Rob Gravelle takes a complex SQL statement and shows you several ways to re-write it that both simplifies and shortens it, while still yielding the same results. >>> More
How do i return integers from a string ?

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 … >>> More
Tip#102: Did you know… How to specify tag specific formatting

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Let’s see this with an example. I have the following html code on my page. Now if I format the document by selecting Edit –> Format document (or Ctrl K, Ctrl D) The document becomes I want the content inside td should remain on the same line Read More......(read more) >>> More

Related posts about Performance

Improving VPN performance - stronger encryption = more performance?

as seen on Server Fault - Search for 'Server Fault'
I have a site-to-site VPN set up with two SonicWall's (a TZ170 and a Pro1260). It was suggested to me that turning off encryption (so the VPN is tunneling only) would improve performance. (I'm not concerned with security, because the VPN is running over a trusted line.) Using FTP and HTTP transfers… >>> More
Inaccurate performance counter timer values in Windows Performance Monitor

as seen on Stack Overflow - Search for 'Stack Overflow'
I am implementing instrumentation within an application and have encountered an issue where the value that is displayed in Windows Performance Monitor from a PerformanceCounter is incongruent with the value that is recorded. I am using a Stopwatch to record the duration of a method execution, then… >>> More
Excel-based Performance Reviews transformed into Web Application for Performance Management

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
HR TMS provides enterprise talent management solutions for healthcare, retail and corporate customers, focusing on performance management, compensation management and succession planning. As the competency of nurses and other healthcare workers is critical, the government, via the Joint Commission… >>> More
How to save a perfmon Performance Counter as a textfile (Reliability and Performance Monitor Version

as seen on Server Fault - Search for 'Server Fault'
Now the file gets saved as blg, but I would like a txt versin to import in Excel. >>> More
SQLAuthority News – A Successful Performance Tuning Seminar at Pune – Dec 4-5, 2010

as seen on SQL Authority - Search for 'SQL Authority'
This is report to my third of very successful seminar event on SQL Server Performance Tuning. SQL Server Performance Tuning Seminar in Colombo was oversubscribed with total of 35 attendees. You can read the details over here SQLAuthority News – SQL Server Performance Optimizations Seminar – Grand… >>> More