SQL Server with Mr. Denny:

Performance Problems


November 20, 2013  2:00 PM

Will SQL Performance Better In A VM?



Posted by: Denny Cherry
24 HoP, Database Administration, Performance, Performance Problems, SQL PASS, SQL PASS 2013, SQL Server

A question came up that during my 24 Hours of PASS presentation a while back. The question was "Is performance of SQL Server 2012 is better in Virtual environment than the Physical?". Now I actually get questions like this all the time when giving presentations.

May 22, 2013  2:00 PM

The Optimizer Isn’t As Smart As You Might Want It To Be



Posted by: Denny Cherry
Database, Database Design, Index Performance, Performance, Performance Problems, Problems, SELECT statement, SQL Server, SQL Server 2008 R2, Stored Procedures, T/SQL, Tables

A little while back I got one of those phone calls.  You know the one, the lovely 6am phone call about random performance problems.  There were two...


May 30, 2012  2:00 PM

Time to vote for vmworld 2012 sessions



Posted by: Denny Cherry
Performance Problems, SQL Server, SQL Server 2012, VMware, VMworld

For those that are interested in the VMware product line and the VMworld conference, it is time to begin the community voting for sessions that will be given at VM World 2012 in both San Francisco, CA USA and Barcelona, Spain. You'll need to register...


March 22, 2012  2:00 PM

How I use sp_whoisactive and sp_who3



Posted by: Denny Cherry
Performance Problems, sp_who3, SQL Server, Troubleshooting

On occasion I'm asked to come and look into some SQL performance problems on systems.  Normally when I'm doing this the customer doesn't have any third party tools installed and they are actively having problems, and these problems are leading to lost revenue or at least really pissed off...


December 15, 2011  2:00 PM

3rd Party Performance Monitoring Tools & CXPACKET



Posted by: Denny Cherry
Performance, Performance Problems, SQL Server, Storage

There are lots of great 3rd party monitoring tools on the market from a variety of vendors.  I want to start this post by saying up front that I'm not bashing them, or throwing stones.  That said... Some of the time these third party apps don't handle reporting CXPACKET waits very well.  The...


September 2, 2011  2:00 PM

VMworld Day 4



Posted by: Denny Cherry
Performance Problems, vCenter, VMware, VMworld, VMworld 2011

Thursday was the final day of VMworld.  Like with all conferences I'm sad that it's over, but I'm damn glad that it's over.  These things are just exhausting to go to. Today was an interesting (and short) day.  On the final day of VMworld, VMware has decided that they won't give a product...


March 9, 2010  8:00 PM

IO, IO, It’s Off To Disk We Go! #TSQL2sDay



Posted by: Denny Cherry
Microsoft Windows, Performance Problems, SQL Server, Storage, TSQL2sDay

So today is #TSQL2sDay, and this months topic is Disk IO.  Storage is something I love working in, so I figured why not, I'll post something. Hopefully everyone knows that your storage solution is the most critical when it...


November 30, 2009  11:00 AM

OPENXML can be a beast sometimes.



Posted by: Denny Cherry
OPENXML, Performance Problems, SQL, Table Variables

Our application includes some search functionality which is pretty complex to deal with.  In a nutshell the user can select multiple values from a couple of lists on the website and use those listed to filter down the rows which are being searched.  These lists are passed into the SQL Server as a...


September 9, 2009  1:55 AM

Whitepaper on why database maintenance is important



Posted by: Denny Cherry
Index Performance, Performance Problems, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, Statistics, White Paper

Today I'm publishing a white paper which I wrote for our Customer Service department to give to our customers. It explains why database maintenance is so important in keeping your database happy and healthy.


August 13, 2009  11:21 AM

Auto Close is almost as bad as auto grow



Posted by: Denny Cherry
Performance Problems, SQL Server

In theory the auto close setting is a great idea. Free up resources for other databases to use when all the users are finished with the database. In practice, its not so great.  If a single user connects and disconnects over and over (like say a single user using your website or even a few...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: