Archives: December 2009
It is pretty common for large, busy SQL Server implementations to run into I/O pressure or bottlenecks, especially since many people seem to buy “big” servers with lots of CPU capacity and lots of RAM, but they treat the I/O subsystem as an afterthought. I have run into this situation… Read more
Perhaps you heard of or actually tried Windows ReadyBoost in Windows Vista, and were (like me) disappointed with the results? The idea behind ReadyBoost is to take advantage of flash memory as a cache for random disk I/O. Microsoft made some improvements to Windows ReadyBoost in Windows 7, which… Read more
Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some sort of a scary warning about how you should not use it on a production system, or else life as we know it will end. For example, Books Online says… Read more
These queries (which work on both SQL Server 2005 and 2008) are very handy if you want to know who is connecting to a SQL Server instance and how they are doing it. It will give you a nice idea how your application or web servers are behaving in terms… Read more
On Monday, Intel officially announced the next generation Atom processors (aka Pineview) that are part of the new Pine Trail platform. According to AnandTech, these new Atoms offer about 5-10% better performance along with 15-20% better battery life. If you have an Atom N270 or N280 based netbook, you… Read more
One thing that I think is very important for a successful DBA to be aware of is their hardware environment. Database servers typically place more demands on their hardware resources than the more common web or application server, and if a database server is under pressure, it can cause lots… Read more
Microsoft's Bob Ward has updated his blog post about documenting SQL Server wait types, that came out of his work at PASS 2009. He is planning on updating his post further as he gets comments and questions on his blog.
You can query your SQL Server 2005/2008 instance to get…
If you are a low-level, bare-metal type of SQL Server geek, you will probably enjoy watching this 60 minute webcast by Microsoft’s Madhan Arumugam and Fabricio Voznika. It has a lot of interesting and useful information on how Microsoft was able to scale up beyond 64 logical processors to 256… Read more
Microsoft has announced the release of CU7 for SQL Server 2005 SP3, which is Build 4273. The link to request the CU from Microsoft is not live yet, but should be pretty soon, hopefully. I count 23 fixes included in this release.
Microsoft has announced the release of CU17 for SQL Server 2005 SP2, which is Build 3356. The link to request the CU from Microsoft is not live yet, but should be pretty soon hopefully. I only see one fix (for MDX) included in this release.
I often work with DBAs who need to copy the results of a T-SQL query from SQL Server Management Studio (SSMS) into some portable format that is easy to save and comprehend. The easiest way that I have found is to right-click on the top left grid cell and choose… Read more
Here is the mid-December version of my diagnostic queries for SQL Server 2008. The idea here is to be able to easily and quickly gather quite a bit of information about your database server instance and individual databases on that instance that can help you detect many SQL Server configuration… Read more
Endgadget has a post up about an upcoming 32nm Westmere family CPU called the Core i7-980X, which will have six cores (12 with hyper-threading), 12MB of shared L3 cache, clocked at 3.33GHz. It will be an “Extreme Edition” processor, which means that you would have to be extremely foolish to… Read more
Here is a collection of five stored procedures that are very useful for monitoring the overall health of a SQL Server 2005/2008 instance. These are instance level queries, not database level queries. They are very easy to periodically call from a Windows or Web client to display these items:
“What’s wrong with the database?" or “I can’t connect to SQL Server” How many times have you heard phrases like that from your developers and QA people? Remember, DBA means “default blame acceptor”, or guilty until proven innocent. I am going to show you how to prove yourself (and SQL… Read more
Microsoft announced today that they are reorganizing and combining the existing Windows Server and Solutions Group and the Windows Azure Group into a new Server & Cloud Division (SCD) that will all be in the Servers and Tools Division, led by Bob Muglia.
Mary Jo Foley has her take on… Read more
Via Twitter, I stumbled upon a link to this newly updated pdf from Joseph Sack and David Ikeda who are instructors for the Microsoft Certified Master: SQL Server 2008 program at Microsoft. I have previously written about the program here. The executive summary is that it is a very… Read more
Microsoft Learning has put up a new Microsoft Student Career Portal that gives advice and links to resources on how students can prepare themselves for careers as Database Administrators, Server Administrators, Consumer Support Technicians, Web Developers and Windows Developers. Each job role has a Student Learning… Read more
Endgadget recently had a post up about the Micron Real SSD C300 family of SATA 6Gbps SSDs that will be available in 128GB and 256GB sizes early next year. Micron has several videos up on their blog that show how a system with this drive performs compared to a standard… Read more
Once you have configured SQL Azure and created a database, you can register your… Read more