March 22, 2012 2:00 PM
Posted by: Denny Cherry
Performance Problems,
sp_who3,
SQL Server,
TroubleshootingOn 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
Posted by: Denny Cherry
Performance,
Performance Problems,
SQL Server,
StorageThere 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
Posted by: Denny Cherry
Performance Problems,
vCenter,
VMware,
VMworld,
VMworld 2011Thursday 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
Posted by: Denny Cherry
Microsoft Windows,
Performance Problems,
SQL Server,
Storage,
TSQL2sDaySo 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
Posted by: Denny Cherry
OPENXML,
Performance Problems,
SQL,
Table VariablesOur 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
Posted by: Denny Cherry
Index Performance,
Performance Problems,
SQL Server,
SQL Server 2000,
SQL Server 2005,
SQL Server 2008,
Statistics,
White PaperToday 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
Posted by: Denny Cherry
Performance Problems,
SQL ServerIn 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...
August 10, 2009 11:08 AM
Posted by: Denny Cherry
Auto Grow,
Performance Problems,
SQL ServerOK, that's not entirely true, but it's pretty damn close. The auto grow feature of SQL Server shouldn't be counted on. It should be disabled, or at least used on as an emergency basis only.
Having the auto grow setting enabled will cause your database to grow when ever it needs to, not when...
December 4, 2008 7:55 AM
Posted by: Denny Cherry
Instant File Initialization,
Performance Problems,
StorageSQL Server 2005 introduced us to Instant File Initialization. This allows SQL Server to create files of any size without sitting there for minutes or hours (depending on the size of the files).
While this is great when creating your database, or extending your database files there is a cost to...
