Viewing 9 posts - 1 through 9 (of 9 total)
http://sqlserverbuilds.blogspot.com/
The source database instance version is 10.00.5775 or SQL Server 2008 SP3 CU4.
The "second run" database instance version is 10.00.5828 or SQL Server 2008 SP3 CU8.
Definitely want to...
October 9, 2014 at 8:29 am
Kevin Dahl - Some relevant details will be whether NUMA pass through is enabled in VMWare. This is enabled by default with more than 8 vCPUs, but for 8...
June 12, 2013 at 10:15 pm
"I still think 2012 is underperforming compared to 2008R2, particularly given it's running on almost double the hardware our old 2008R2 box was."
This is a big clue. Have you...
April 24, 2013 at 9:11 am
I've rambled about it somewhat incoherently at sql-sasquatch.blogspot.com. (sql_handle, lonnyniederstadt, sql_sasquatch are all me - there's an idea behind my multiple identites that I'm notmanaging too well yet across multiple...
April 19, 2013 at 5:15 am
Depending on your workload, even with MSSQL 2012 SP1 CU3 in place, there may be significant gains in running with startup trace flags 8015 and 8048 in place. 8015...
April 11, 2013 at 4:25 am
Here's the thing: the SQL Server 2012 SP1 CU3 fix is probably a good thing - I'm waiting on more details on it. But, the behavior it addresses goes...
April 11, 2013 at 3:24 am
Yep, zeros for me, too.
I've got these counters added. All of them have values as expected except the local and remote lookups/sec. I've seen this behavior in SQL...
April 10, 2013 at 1:02 pm
Key findings on the troubled system:
- From Perfmon, 15 second intervals
- - System remains at 95%-100% CPU busy
- - SQL Server buffer page lookups < 10000 per/second
- From wait and...
November 14, 2012 at 5:05 pm
About the system:
- 4 hex core Xeon E7540 @ 2.00GHz, hyperthreaded
- 128 GB RAM
- WS2008R2
- MSSQL 2008 R2 SP2
- maxdop 6
About the workload:
- 1000s of Batch scheduled/queued...
November 14, 2012 at 4:48 pm
Viewing 9 posts - 1 through 9 (of 9 total)