August 2010 - Posts

Meet the authors at SQLBits 7 – Professional SQL Server 2008 Internals and Troubleshooting
24 August 10 09:47 AM | Christian | 1 comment(s)

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:PACKED full of goodness

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

SQL Server perfmon counters and DMVs return zero values
23 August 10 01:32 PM | Christian | with no comments

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

Coeo are giving away a Fusion-IO card at SQLBits
18 August 10 03:33 PM | Christian | 1 comment(s)

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/You need this in your life

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

Filed under: ,