Archives: October 2009
It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something besides the default setting (which allows SQL Server to use as much memory as it wants, subject to signals from the operating system that it is under memory pressure). This…
Besides giving two Community Session presentations (here and here), next week, I will be involved in the Birds of a Feather (BOF) Lunch on Tuesday, November 3 at 11:30AM and the SQL Server MVP Deep Dives Book Launch and Signing on Wednesday, November 4 at 11:30AM. These are… Read more
Mike Walsh, who is a PASS volunteer, has done a nice job organizing the PASS Summit Birds of a Feather Lunch, on Tuesday, November 3 at the PASS Summit in Seattle. You might be wondering what this is. In Mike’s words:
The Birds of a Feather event is a…
Microsoft released Cumulative Update 6 for SQL Server 2005 SP3 yesterday (and the KB link is working today). This is Build 4266. There are over twenty fixes included in the CU, including a couple for database mirroring. All of the post-SP3 builds are listed here.
They also released CU… Read more
Lots of interesting news and announcements coming out of the SharePoint 2009 Conference that started today in Las Vegas. Microsoft’s Jie Lie has a good post up describing the technical requirements for SharePoint 2010, which include requiring x64 Windows Server 2008 or Windows Server 2008 R2 (which is x64 only),… Read more
Mary Jo Foley posted about Visual Studio 2010 Beta 2 being available on the MSDN Subscriber’s site today, so I popped over to check, and sure enough it was there, relatively early in the day. She claims that it is supposed to RTM in March 2010.
I also noticed that… Read more
Last night, I received my hard-copy of Pro SQL Server 2008 Mirroring from APress. This book has a lot of useful information and code to help you easily create and monitor database mirrors in SQL Server 2008. I was the technical reviewer for the book, which was a lot of… Read more
As I work on moving a large system with multiple database servers from a 27TB SAN to a single database server with about 6TB of direct attached storage (DAS), I have to worry much more about space utilization. The stakes are also a little higher, since it is much harder… Read more
My long awaited new database server arrived today! It has two, quad-core Xeon X5550 processors, 72GB of DDR3 RAM, and eight 73GB 10K SAS drives. I have hyper-threading enabled, so the OS sees 16 cores. Intel offers two slightly faster processors in the Xeon 55xx family, but they are considerably… Read more
Microsoft has announced the upcoming end of mainstream support for SQL Server 2005 SP2 on January 12, 2010, and for SQL Server 2008 RTM on April 13, 2010. This just means that you need to upgrade to a newer Service Pack by then (which you should do anyway, IMHO).
They… Read more
One thing you need to be careful about with SQL Server 2005/2008 Database Mirroring is making sure that you don’t exceed the I/O capacity of the storage subsystem of the SQL Server instance where the mirrored database lives. If you do this with High Safety mode (synchronous) mirroring, your applications… Read more
I happened upon the screenshot below, showing a stress test in progress against a Windows machine with 64 quad-core CPUs (which gives you 256 cores). This requires Windows Server 2008 R2 Datacenter Edition, along with SQL Server 2008 R2. As Microsoft puts it:
“SQL Server 2008 R2 helps…
Fellow MVP, Paul Randal from SQLSkills.com has published a 35 page white paper on MSDN called “High Availability with SQL Server 2008”. This is an excellent resource on the subject of high availability, full of useful information and lots of links to other HA knowledge.
I was lucky… Read more
Here is the October 2009 version of my SQL Server 2008 Diagnostic Information Queries. They are very useful for gathering information about a SQL Server 2008 instance and a particular database on that instance. Many of the queries are DMV queries that require VIEW_SERVER_STATE permission to run.
You can download… Read more
AnandTech has another I.T. oriented post up comparing the performance and value of two-socket servers to four-socket servers. The gist of the story is that in most cases, a dual-socket system based on the Intel Xeon 55xx CPU performs as well or better that either a quad-socket Intel Xeon 74xx… Read more
This shows you how to diagnose and correct a "runaway" transaction log. This is a very common issue that I often see with customers and on the MSDN forums. You will see the error message below when this happens:
"The transaction log for database 'ngservices' is full. To find out…
I live in Parker, Colorado, which is a suburb of Denver, about 25 miles southeast of downtown Denver. I have lived here for about ten years, and I have seen Parker grow quite a bit (to a population of about 30,000), but it still has a small town feel.… Read more
Well, I just learned a valuable lesson about something you should not do as a DBA…
About a month ago, a client of mine called me to report that their main database server was running critically short of disk space on the C: drive. Whoever had installed the operating system,… Read more
The "SQL Server MVP Deep Dives" book that I wrote two chapters for is up for pre-order. This will be an amazing book, crammed full of great material, by so many very well known SQL Server experts.
Fifty-three SQL MVPs contributed to the book, and all author royalties are being…