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

Archives: March 2010

Intel Xeon 7500 Series aka Nehalem-EX

Intel has finally released the long awaited (at least by me) 45nm Xeon 7500 series processor. This beast has eight cores, plus hyper-threading and turbo boost, and 24MB of shared L3 cache. It also supports up to 16 DDR3 memory slots per CPU socket. This would give you 64… Read more

0 comments, 818 reads

Posted in Glenn Berry's SQL Server Performance on 31 March 2010

SQL Server 2008 Database Mirroring: It takes a licking but it keeps on ticking!

With apologies to Timex, I just wanted to relate a minor incident that happened with one of my mirrored databases last night. This database needed to grow its primary data file, and the autogrow amount was set to 5GB ( I have Windows Instant File Initialization enabled). Unfortunately, there was… Read more

2 comments, 3,166 reads

Posted in Glenn Berry's SQL Server Performance on 30 March 2010

Using Custom Connection Colors in SSMS

One of the new features that was added to SQL Server Management Studio (SSMS) in SQL Server 2008, which was continued in SQL Server 2008 R2, is the ability to set custom connection colors for individual instances of SQL Server. The color you set shows up in the bottom of… Read more

9 comments, 1,722 reads

Posted in Glenn Berry's SQL Server Performance on 29 March 2010

To Get Certified or Not Get Certified

I have noticed quite a bit of discussion recently about the merits of Microsoft certification. Some people (like me) think that getting a Microsoft certification is a good thing. It proves that you have at least a certain level of competence with the product, and it shows that you have… Read more

3 comments, 385 reads

Posted in Glenn Berry's SQL Server Performance on 29 March 2010

Recovery Models and Backup Strategies for SQL Server 2008

I had a question via e-mail from one of my new students at University of Denver, University College this morning, asking why the transaction log on one of his SQL Server databases seemed to fill up so quickly, and then grow in size.  This is probably one of the most… Read more

0 comments, 2,077 reads

Posted in Glenn Berry's SQL Server Performance on 25 March 2010

Creating SQL Server 2008 Databases with T-SQL

Imagine you need to create a database on a customer’s machine, but you don’t know how they have their file system laid out. You can take advantage of the fact that SQL Server keeps track (at the instance level) of the default location for SQL Data files and SQL Log… Read more

1 comments, 711 reads

Posted in Glenn Berry's SQL Server Performance on 24 March 2010

Why UniqueIdentifier is a Bad Choice for a Clustered Index in SQL Server

I had a question today about why it was “bad” to use a UniqueIdentifier as the data type for a clustered index in SQL Server. After all, on the surface that sounds like a good choice, since a UniqueIdentifier is guaranteed to be unique, right?  I have run into many… Read more

30 comments, 5,456 reads

Posted in Glenn Berry's SQL Server Performance on 22 March 2010

SSWUG Ultimate vConference Discount Code

The SSWUG Ultimate Virtual Conference is coming up on April 7, 8, and 9th.  This is three days of very useful SQL Server content that you can watch from the comfort of your computer, with no travel time or travel expenses involved. There is a slate of great speakers,… Read more

0 comments, 363 reads

Posted in Glenn Berry's SQL Server Performance on 22 March 2010

The Coming Upgrade Tidal Wave

Microsoft is poised to release new versions of several different products and technologies that have the potential to have a big, positive impact on the life of the average DBA, as long as you position yourself to take advantage of them properly. Intel has released the new Xeon 5600 series,… Read more

0 comments, 303 reads

Posted in Glenn Berry's SQL Server Performance on 18 March 2010

Intel Xeon 56xx Series Westmere-EP Review

AnandTech IT has a quick review of the upcoming six-core, 32nm Intel Xeon 56xx processor, which includes several different database benchmarks. Their conclusion is that this CPU is a significant improvement over the very impressive Intel Xeon 55xx processor, and that it simply dominates anything that AMD currently has available.… Read more

0 comments, 872 reads

Posted in Glenn Berry's SQL Server Performance on 16 March 2010

SQL Server 2008 SP1 CU7 is Released

Microsoft has released SQL Server 2008 SP1 Cumulative Update 7 (CU7). It is Build 2766. There are 31 fixes listed, many of which are for SSRS, SSIS, and SSAS. They have also released SQL Server 2008 RTM Cumulative Update 10 (CU10), which is Build 1835.

As I have said before,… Read more

0 comments, 793 reads

Posted in Glenn Berry's SQL Server Performance on 16 March 2010

How to Enroll a Managed Instance into SQL Server Utility in SQL Server 2008 R2

After creating a Utility Control Point (UCP) you will want to enroll some managed instances (up to 25 with SQL Server 2008 R2 Enterprise Edition) into your Utility Control Point. Remember, any managed instances must also be SQL Server 2008 R2 (as of the November 2009 CTP of SQL… Read more

1 comments, 573 reads

Posted in Glenn Berry's SQL Server Performance on 16 March 2010

Denver SQL Server User’s Group Meeting on March 18

The Denver SQL Server User’s Group will be having their March meeting on Thursday, March 18. Bulent Gucuk will discuss SQL Server Replication basics. The second speaker will be Dean Richards of Confio Software, giving a presentation on using Wait Time Analysis.

The meeting will be held at Ameriteach,… Read more

0 comments, 350 reads

Posted in Glenn Berry's SQL Server Performance on 15 March 2010

SQL Server Utility in SQL Server 2008 R2

One of the new management related features in SQL Server 2008 R2 is SQL Server Utility. SQL Server Utility gives you a way to manage and monitor multiple instances of SQL Server using a variation of Management Data Warehouse. You can use this to monitor things such as CPU utilization… Read more

4 comments, 2,595 reads

Posted in Glenn Berry's SQL Server Performance on 15 March 2010

SharePoint 2010 and Various Versions of SQL Server

Microsoft has recently announced that SharePoint 2010 and Office 2010 will RTM in April 2010, and will be officially launched on May 12, 2010. From historical experience, this means that the RTM bits will be available on MSDN Subscribers probably one to two weeks after it is declared RTM, and…

Read more

0 comments, 3,108 reads

Posted in Glenn Berry's SQL Server Performance on 11 March 2010

How to Easily Log SQL Server 2008 Instance Level Metrics

If you want to record the results of some useful, instance level DMV queries somewhere where you can easily query them later, you can use this technique.  This gives you a pretty decent overview of the health of your instance by capturing AvgTaskCount, AvgRunnableTaskCount, AvgPendingIOCount, SQlServerCPUUtilization, and PageLifeExpectancy on a… Read more

3 comments, 518 reads

Posted in Glenn Berry's SQL Server Performance on 9 March 2010

Easy Ways to Detect I/O Pressure in SQL Server 2008

It is pretty common for large, busy SQL Server instances to run into I/O bottlenecks. Even smaller, less busy systems often run into problems when they are not sized and configured correctly. As a database professional, you need to be able to detect when your SQL Server instances are experiencing… Read more

12 comments, 3,223 reads

Posted in Glenn Berry's SQL Server Performance on 9 March 2010

T-SQL Tuesday #004 Hosted by Mike Walsh

I just wanted to remind people to participate in T-SQL Tuesday #004 on the subject of IO. You just need to post a blog post on something to do with IO between 00:00:00 UTC on Tuesday the 9th of March and 00:00:00 UTC on Wednesday the 10th. You… Read more

0 comments, 284 reads

Posted in Glenn Berry's SQL Server Performance on 8 March 2010

More SQL Azure Samples

I have been playing around some more with SQL Azure in order to get ready for an upcoming presentation, so I thought I would share some of the T-SQL commands in the script below. I have a partial copy of the sample AdventureWorksLT2008R2 database installed on my SQL Azure logical… Read more

23 comments, 1,083 reads

Posted in Glenn Berry's SQL Server Performance on 5 March 2010

Using the OUTPUT clause to retrieve new identity values from SQL Server 2008

Microsoft has a new KB article outlining issues with using SCOPE_IDENTITY and @@IDENTITY to retrieve values inserted into an identity column in a table. This particular issue shows up when you have parallel execution plans, but I have also seen DML triggers cause problems when you use @@IDENTITY.  The article… Read more

1 comments, 1,444 reads

Posted in Glenn Berry's SQL Server Performance on 3 March 2010