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

Archives: January 2011

My Thoughts on the Intel Sandy Bridge Chipset Recall

I awoke this morning to see a number of stories breaking about the Intel Sandy Bridge H67/P67 Chipset Recall. I also had a number of Tweets directed at me (@GlennAlanBerry) and several e-mails from people asking me what I thought about this.

First, I hate to see something like this… Read more

0 comments, 898 reads

Posted in Glenn Berry's SQL Server Performance on 31 January 2011

Building an Extremely Power Efficient Intel Sandy Bridge Desktop System

Since I have a 3.15Kw grid-tied Solar PV System on the roof of my house in Parker, I pay pretty close attention to my electrical power usage. I try to generate more electricity than I use, because I care about the environment and because I hate my electric company ( Read more

0 comments, 959 reads

Posted in Glenn Berry's SQL Server Performance on 31 January 2011

Microsoft Support Policies for Windows Server and SQL Server

Microsoft provides ten years of support (five years Mainstream Support and five years Extended Support) at the supported service pack level for Business and Developer products, which include Windows Server and SQL Server. The term “supported service pack level” means that you cannot be on a retired service pack (which… Read more

3 comments, 2,401 reads

Posted in Glenn Berry's SQL Server Performance on 31 January 2011

Speaking at the Rocky Mountain Tech Trifecta on March 5

I just got the notification that I will be one of the speakers at the Rocky Mountain Tech Trifecta on March 5, 2011 in Denver, Colorado. This event (which is in its third year) is like a mixture of a SQLSaturday and a Code Camp, with tracks devoted to SQL… Read more

0 comments, 202 reads

Posted in Glenn Berry's SQL Server Performance on 28 January 2011

Speaking at SQLSaturday #66 in Colorado Springs on February 12

I recently found out that I will be one of the speakers at SQLSaturday #66 on February 12 in Colorado Springs. I will be talking about hardware evaluation and selection, and the full abstract is below:

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

The foundation of database… Read more

0 comments, 246 reads

Posted in Glenn Berry's SQL Server Performance on 21 January 2011

Another Example of CPU Throttling Due to Balanced Power Plan in Windows Server 2008 R2

Here is another example CPU throttling from someone who had a server running with the default “Balanced” Power Plan in Windows Server 2008 R2 (which works the same way in Windows Server 2008). 

As you can see in Figure 1 below, the Core Speed with the Balanced Power Plan is… Read more

3 comments, 1,435 reads

Posted in Glenn Berry's SQL Server Performance on 18 January 2011

New Cumulative Updates for SQL Server 2008 SP1 and SP2

Microsoft has released new cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2. Remember, both of these are completely separate from SQL Server 2008 R2 (which is considered a separate, major release from SQL Server 2008).

The first cumulative update is SQL Server 2008 SP1 CU12 Read more

0 comments, 363 reads

Posted in Glenn Berry's SQL Server Performance on 18 January 2011

Denver SQL Server User’s Group Meeting on January 20, 2011

My good friend, Kevin Cox, of Microsoft’s SQLCAT (SQL Customer Advisory Team) will be giving a presentation on what is new in SQL Server “Denali” at the Denver SQL Server User’s Group Meeting on Thursday, January 2011. The meeting place has changed back to the Microsoft office in the… Read more

0 comments, 263 reads

Posted in Glenn Berry's SQL Server Performance on 14 January 2011

How to Obtain and Install SQL Server Service Packs and Cumulative Updates

If you are in charge of one or more SQL Server instances, whether they are on a laptop, or a large Production data center, you need to be aware of how SQL Server updates and fixes are released, and how you can obtain them.

First, a few definitions:

RTM means…

Read more

0 comments, 1,412 reads

Posted in Glenn Berry's SQL Server Performance on 12 January 2011

Intel Processor Information

Here is a small collection of links to tools for measuring and evaluating mobile and desktop processors, along with some marketing hype from Intel about Sandy Bridge.

CPU Reviewer Kit for Intel Sandy Bridge

Intel Processor Comparison Tool

How to choose the right processor

Intel Processor Information

CPU-Z info for… Read more

1 comments, 514 reads

Posted in Glenn Berry's SQL Server Performance on 11 January 2011

Fun with Extended Properties in SQL Server 2008

Most technical professionals don’t seem to enjoy writing and maintaining documentation for their databases. I know that documentation falls pretty low on my favorites list.

One pretty easy way to include some “built-in” database documentation for your databases (which could be the beginnings of a data dictionary) is to add… Read more

3 comments, 1,752 reads

Posted in Glenn Berry's SQL Server Performance on 10 January 2011

My First Sandy Bridge Desktop System

I was standing in line at the Denver Micro Center at 11AM this morning (despite the beginnings of a small blizzard), so I could get my hands on a 32nm Intel “Sandy Bridge” Core i7 2600K processor. It is a good thing I was there early, since they only… Read more

2 comments, 849 reads

Posted in Glenn Berry's SQL Server Performance on 10 January 2011

Microsoft Certified Master in SQL Server 2008 Knowledge Exam

I woke up bright and early this morning to take the beta version of the Microsoft Certified Master in SQL Server 2008 Knowledge Exam at a Prometric Testing center in Greenwood Village, CO. Since 1995, I have passed about 25 different Microsoft Certification exams, including several beta exams. My first… Read more

2 comments, 514 reads

Posted in Glenn Berry's SQL Server Performance on 8 January 2011

Bad DBA or Bad Developer?

I was browsing a public web site from a large company today, when I saw the error page shown below.  It looks like they are using ColdFusion to talk to SQL Server using JDBC, and they are missing a stored procedure called getBladeList.  This made me curious as to what… Read more

2 comments, 258 reads

Posted in Glenn Berry's SQL Server Performance on 8 January 2011

SQL Server Index Tuning for Mere Mortals

One of the most important things to measure, monitor, and “get right” for good overall SQL Server OLTP performance is the number and composition of your SQL Server relational indexes. It is extremely important to have neither too many or too few relational indexes on each table, and that the… Read more

2 comments, 1,569 reads

Posted in Glenn Berry's SQL Server Performance on 7 January 2011

Microsoft DreamSpark for Students

If you are a college or high school student, you can get a very valuable assortment of free software from the Microsoft DreamSpark program. As Microsoft says on the web site:

DreamSpark is simple:

It’s about giving students Microsoft professional tools at no charge

You can get things like Visual…

Read more

0 comments, 605 reads

Posted in Glenn Berry's SQL Server Performance on 4 January 2011

Lots of Intel Sandy Bridge News Today

Intel has lifted the embargo today on 32nm Intel Sandy Bridge benchmarking, so there is a lot of good information out there now. If you are in the market for a new laptop in the near future, I would be looking for a system with an Intel Core i7-2820QM processor,…

Read more

0 comments, 363 reads

Posted in Glenn Berry's SQL Server Performance on 3 January 2011

TPC-E Benchmark Analysis by CPU Type

As an experiment, I decided to import the current official TPC-E results spreadsheet into a SQL Server 2008 R2 database, so I could easily query and do some basic analysis against the results. I did a little data cleansing so that the data would always use the same terms for…

Read more

0 comments, 529 reads

Posted in Glenn Berry's SQL Server Performance on 1 January 2011