Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: October 2009

Suggested Max Memory Settings for SQL Server 2005/2008

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…

Read more

74 comments, 150,095 reads

Posted in Glenn Berry's SQL Server Performance on 29 October 2009

Special Events at PASS Summit

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

0 comments, 218 reads

Posted in Glenn Berry's SQL Server Performance on 26 October 2009

PASS Summit Birds of a Feather Lunch

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…

Read more

0 comments, 409 reads

Posted in Glenn Berry's SQL Server Performance on 21 October 2009

SQL Server 2005 SP3 CU6 Released

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

0 comments, 634 reads

Posted in Glenn Berry's SQL Server Performance on 20 October 2009

SharePoint 2010 And SQL Server 2008 R2

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

1 comments, 1,430 reads

Posted in Glenn Berry's SQL Server Performance on 19 October 2009

Visual Studio 2010 Beta 2 Available On MSDN Subscribers

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

0 comments, 212 reads

Posted in Glenn Berry's SQL Server Performance on 19 October 2009

More SQL Server 2008 Book Involvement

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

0 comments, 225 reads

Posted in Glenn Berry's SQL Server Performance on 15 October 2009

What Is Using The Most Space In Your Database ?

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

0 comments, 465 reads

Posted in Glenn Berry's SQL Server Performance on 14 October 2009

New Dell PowerEdge R710 Database Server

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

0 comments, 900 reads

Posted in Glenn Berry's SQL Server Performance on 9 October 2009

SQL Server Announcements From Microsoft

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

1 comments, 439 reads

Posted in Glenn Berry's SQL Server Performance on 9 October 2009

What a backed up Database Mirror looks like

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

1 comments, 721 reads

Posted in Glenn Berry's SQL Server Performance on 9 October 2009

A DBA’s Fantasy

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…

Read more

5 comments, 671 reads

Posted in Glenn Berry's SQL Server Performance on 8 October 2009

Very Useful SQL Server 2008 High Availability White Paper On MSDN

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

0 comments, 318 reads

Posted in Glenn Berry's SQL Server Performance on 8 October 2009

Updated SQL Server 2008 Diagnostic Information Queries

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

2 comments, 642 reads

Posted in Glenn Berry's SQL Server Performance on 7 October 2009

More SQL Server Benchmarks From AnandTech

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

0 comments, 357 reads

Posted in Glenn Berry's SQL Server Performance on 6 October 2009

How to Diagnose and Correct a “Runaway” Transaction Log

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…

Read more

5 comments, 5,866 reads

Posted in Glenn Berry's SQL Server Performance on 5 October 2009

A Tale of Two Utility Companies

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

0 comments, 196 reads

Posted in Glenn Berry's SQL Server Performance on 5 October 2009

Stupid DBA Tricks

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

3 comments, 2,040 reads

Posted in Glenn Berry's SQL Server Performance on 4 October 2009

SQL Server MVP Deep Dives Book available for pre-order

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…

Read more

0 comments, 208 reads

Posted in Glenn Berry's SQL Server Performance on 2 October 2009