-
-
Five of the authors of Professional SQL Server 2008 Internals and Troubleshooting will be at SQLBits 7 next month which is the first time so many of us have been at a conference together. Four of us will be speaking, here is the line-up:
30th Sept
Brent Ozar: Virtualization, SAN and SQL Server: The Perfect Storm (Full-day pre-con)
1st Oct
Brent Ozar: Virtualization and SAN Basics for DBAs
Jonathan Kehayias: An Introduction to Extended Events
Christian Bolton: Consolidating data collection with SQLDIAG and analysing it in SQLNexus
Justin Langford: Notes from the field: High-Performance storage for SQL Server
2nd Oct
Brent Ozar: SQL Server Storage – 1,000GB Level
The first day has 7 pre-cons for you to choose from, the second day is jam-packed with MVP’s and other awesome speakers and the third day is absolutely FREE to attend. Sign-up here: http://www.sqlbits.com
I hope to see you there!
btw, Coeo are giving away a Fusion-IO card, did I mention that ;) http://bit.ly/ac5VCz
Regards,
Christian Bolton - MCA: SQL Server 2005, MCM: SQL Server 2005/2008, MVP
Technical Director
http://coeo.com - SQL Server Consulting & Managed Services
-
-
I came across an interesting issue today where all the SQL Server performance monitor counters existed but all returned a zero in the results. Querying sys.dm_os_performance_counters also produced zero rows.
After a bit of head scratching and searching I found an MSDN forum post with the answer posted by Ivan Penkov from Microsoft: http://tinyurl.com/25w8vxo
If you change the service account for SQL Server while another process in reading the perfmon counters, “the shared memory section which contains the counter values and which is created under the old service account is kept alive [and] the new service account doesn’t have access to it”.
What was especially interesting was that the problem persisted through a reboot of the server.
In our case, the server was in a managed data centre and whilst we had disabled our own monitoring there was another service reading the perfmon counters when I changed the SQL Server service account and caused the issue that Ivan describes.
After stopping the hosting company’s monitoring service and restarting the SQL Server service everything was working again.
If only more issues were as straightforward as this to fix!
Regards,
Christian
Christian Bolton - MCA: SQL Server 2005, MCM: SQL Server 2005/2008, MVP
Technical Director
http://coeo.com - SQL Server Consulting & Managed Services
-
-
I am very excited to announce that to celebrate Coeo’s recent partnership with Fusion-IO we’ll be giving away an 80GB Fusion-IO ioEXTREME card to a lucky attendee at SQLBits.
If you’ve never looked at Fusion-IO before, now is your chance to check-out what you’ve been missing.
Have a look at the official product page for this card here:
http://www.fusionio.com/products/ioxtreme/
and then check-out Brent Ozar’s Fusion-IO review here:
http://www.brentozar.com/archive/2010/03/fusion-io-iodrive-review-fusionio/
The card we’re giving away is intended to supercharge a workstation and only requires a free PCI-E slot on your motherboard to install. Its capable of reading 64K packets at 670MB/s with an access latency of 80 microseconds. Remember when you were happy if SQL Server had <5 milliseconds of disk latency?
Watch this space for more details on the competition. You’ll have to be at SQLBits in York to be in with a chance so if you haven’t registered already click here to sign-up: http://www.sqlbits.com
See you all there in September!
Regards,
Christian
Christian Bolton - MCA: SQL Server 2005, MCM: SQL Server 2005/2008, MVP
Technical Director
http://coeo.com - SQL Server Consulting & Managed Services