All to often when people deal with parallel queries they see that some threads of the query have a wait type of CXPacket so they assume that the parallel execution plan is causing a problem, but it probably isn’t.
Everyone likes nice defragmented SQL Servers. However if you use Diskeeper to do so be very careful before you upgrade to the new version 10, or if you are going to upgrade to the new version 10 you’ll need to make a small change to your configuration on each SQL Server.
All to often I see people online saying that they detach a database then delete the log file to shrink it. This is a very dangerous operation which can leave you with a corrupt database that you can’t do anything with. Continued »
SAN replication is a very power tool which will let you get real time (or near real time) backups of your database on another location on your storage array, to another storage array at the local site, or to a remote storage array at another site.
However like all technologies there are some things which it is really good at, and some things which it can’t/shouldn’t be used for. (Everything here is going to be SAN vendor dependent. This includes features, modules you have to buy, terminology, and probably some other stuff I’m not thinking of.) Continued »
Proper network design is very important to ensuring the highest availability between your storage array and your server. This design is important weither you are using a Fibre Channel SAN or an iSCSI SAN. The basic design is the same. Continued »
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 couple of XML documents. We recently had a larger customer call and complain that the search was slow. I fired up profiler and grabbed the query. They were right, 6 minutes is a long time for a query to take. Continued »
What server upgrade would be complete without some Active Directory enhancements? This release is no exception.
One of the best enhancements (in my opionion) is that Active Directory now has a recycle bin. Continued »
A little while back I posted about how to move a standalone instance to a clustered instance using a different name and IP, but what do you do when you need to keep the same name and IP address? This is a much more complex procedure to complete. Continued »
This week I’ve got 4 presentations and two different events so I’m posting everything in a single post.
On Wednesday I’ll be presenting at the San Gabrial Valley .NET User Group. I’ll be giving my SQL Service Broker presentation.
Then this weekend at the SoCal Code Camp I’ll be giving three presentations. The first one is Reading the SQL Server Execution Plan, the second is SQL Server Indexing for the Client Developer and the third is Storage for the DBA.
Feel free to download the slide decks ahead and time.
Once you’ve setup a good redundant network design you need to invenst in some goo multi-pathing software to ensure that you are making the most of the redundant network that you have created. Continued »