SQL Server with Mr. Denny:

Performance

1

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 16, 2012  9:16 PM

Time to Register for TechEd pre-cons



Posted by: Denny Cherry
Performance, Pre-Con, SQL Server, SQL Server 2008 R2, SQL Server 2012, Tech Ed, Tech Ed 2012, Tech Ed Europe, Tech Ed North America, Tom LaRock

So Microsoft TechEd is quickly approaching. If you wanted to sign up for a pre-con there is still time, and plenty of space left available at both the North America and Europe TechEd pre-cons. These pre-cons are full day long sessions, being presented in this case by Tom LaRock and...


February 6, 2012  2:00 PM

Stop putting it off, it’s time to sign up for SQL Pre-Cons



Posted by: Denny Cherry
In Person Events, Performance, Query tuning, SQL Server, Tech Ed, Tech Ed 2012, Tech Ed Europe, Tech Ed North America

If you are headed to Microsoft's Tech Ed North America or Tech Ed Europe you should really look at signing up for a SQL Server Pre-Con.  The pre-cons are full day sessions focusing on a specific topic, led by an industry expert.  In the case of the SQL Server pre-con "Microsoft SQL Server...


January 10, 2012  12:20 AM

Europe just can’t get rid of me!



Posted by: Denny Cherry
Performance, SQL Server, Tech Ed, Tech Ed 2012, Tech Ed Europe

No matter how hard Europe tries to keep me away, I'll be back in June for the premier Microsoft conference, Tech Ed Europe 2012. And not only will I be attending, but little old me will be presenting a


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...


November 21, 2011  2:00 PM

Disk Design for vCenter database



Posted by: Denny Cherry
Performance, SQL Server, Storage, vCenter, VMware

Like all databases the VMware vCenter database needs to have the disks configured properly for best possible performance.  Don't get me wrong, if you've got a very small vCenter database that's only a couple of gigs in size then the disk size isn't all that big of a...


September 8, 2011  7:53 PM

24HOP: BI Workload Follow-Up



Posted by: Denny Cherry
24 HoP, Integration Services, Performance, RAM, SQL PASS, SQL Server, SSIS, Stacia Misner

This is a total repost of Stacia's blog post from this morning so that hopefully everyone will see it.  So pretend that Stacia wrote this and that I didn't.

Yesterday,...


1

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: