Comments for SQL Server Internals and Troubleshooting

Comment on Chapter 11 – SQLDiag and PerfStats by Harvey Mace

Harvey Mace — Tue, 05 Apr 2011 13:59:59 +0000

Hi Mladen
this was frustrating me for a while too. I chopped everything out of the .XML file until I found out you have to change ssver from 10 to 10.5 (2008R2 is version 10.5)
Harvey

Comment on Chapter 11 – SQLDiag and PerfStats by Mladen Andrijasevic

Mladen Andrijasevic — Tue, 29 Mar 2011 15:14:08 +0000

Do PerfStats and SQLDiag run under SQL S2008 R2 RTM?

I had no problem running PerfStats,SQLDiag and SQL Nexus
under SQL 2008 SP2 but when I try running

StartSQLDiagTrace2008.cmd with SQLDiagPerfStats_Trace2008.XML
under SQL S2008 R2 RTM

I get

2011/03/29 13:24:35.69 SQLDIAG There are no instances of version 10 on this computer

2011/03/29 13:24:35.69 SQLDIAG . Function result: 87. Message: The parameter is incorrect.

Is this a known problem?

Thanks

Comment on Steven Wort by Ben Seaman

Ben Seaman — Mon, 18 Oct 2010 13:48:41 +0000

Thanks for the quick response Brent – and that makes sense. I suppose I just thought that since the main cause of concern with hyperthreading for SQL seems to be parallelization of queries onto ‘fake’ cores leading to contention between the HT pair (if they are both chosen to handle threads for the same query), that at least you could see if your queries sped up by taking them out of the affinity mask.

Comment on Steven Wort by Brent Ozar

Brent Ozar — Mon, 18 Oct 2010 13:11:37 +0000

Ben – no, unfortunately, that doesn’t give you the same effect. Remember that the OS, drivers, and background tasks will still be running and unaffected by the affinity mask. They’ll still be submitting work to the CPUs.

Comment on Steven Wort by Ben Seaman

Ben Seaman — Mon, 18 Oct 2010 13:09:38 +0000

Hi Steven,

On pages 140-141 where you talk about the use of hyperthreading and the fact that you may not see any improvement for OLTP workloads (or in fact a degradation). I would like to test my system but ideally don’t want to reboot my server and change the BIOS setting. I was wondering about just setting the affinity mask so that each even CPU core was deactivated (my server is dedicated to SQL and has only one instance). Would you agree that this would have the same net effect as disabling hyperthreading? It would have the advantage of not emptying my plan cache/buffer pools as well as obviously not causing any downtime.

Cheers,
Ben

Comment on Great Book Reviews of Professional SQL Server 2008 Internals and Troubleshooting by Senthilnathan Thiru

Senthilnathan Thiru — Tue, 05 Oct 2010 21:15:51 +0000

Professional SQL Server 2008 Internals and Troubleshooting is a great reference and learning guide for DBA’s and database developers.
A great addition to your reference library.

Comment on SQL Server 2008 Internals & Troubleshooting by Brent Ozar

Brent Ozar — Tue, 03 Aug 2010 15:06:53 +0000

Yes, just go to the Wiley site for our book and it’s listed in the download page. Thanks!

Comment on SQL Server 2008 Internals & Troubleshooting by Bryn Ellis

Bryn Ellis — Tue, 03 Aug 2010 13:01:09 +0000

Brent

Wonder if you got anywhere with finding out how to download Chapter 16 of the book?

Regards
Bryn

Comment on Reviews by Brent Ozar

Brent Ozar — Fri, 21 May 2010 12:21:08 +0000

Thanks, Anu, glad you liked it!

Comment on Reviews by Anu Chawla

Anu Chawla — Thu, 20 May 2010 21:46:24 +0000

This is a great book which I have been recommending to my ISV Partners and Customers. The authors have done an excellent job of taking very important concepts and making them easy to understand. The scripts that are available on the web and accompany the book will make the DBA job easier.
Great Work!