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

Archives: January 2010

Paul Randal’s Benchmarking Series

Fellow SQL MVP Paul Randal of SQLSkills, (who is also Kimberly Tripp’s husband, and a former long-time Microsoft employee) has been working hard on a great benchmarking series with some actual Dell server hardware that he has setup in his house (and I thought I was a geek). His… Read more

0 comments, 1,350 reads

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

Are You Running the x86 Version of SQL Server 2005/2008?

If so why?  Honestly, I am curious why people may still be running 32-bit versions of SQL Server 2005, 2008, or 2008 R2 in a production environment.  I have been advocating that people use 64-bit versions of SQL Server 2005 and above for some time now. NewsGator’s production SQL Server… Read more

27 comments, 1,305 reads

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

Living with TED 5000

Since I installed my TED 5000 home energy monitor about a week ago, I have learned quite a bit about my electricity usage patterns in a pretty short time. I have been averaging between 14-17 KwH per day (which would be 420-510 Kwh for the month). The lowest real time… Read more

5 comments, 409 reads

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

Are You on Twitter?

Like many busy DBAs, I used to be very dismissive of Twitter. It seemed like a self-indulgent waste of time. After all, who cares what I am doing at any given time? Did I really care that someone was reading the paper, sipping some good coffee?

Well, I decided to… Read more

8 comments, 565 reads

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

Setting a Dedicated Login To Run DMV Queries in SQL Server 2005\2008

In order to run server scoped DMV queries, you must have VIEW SERVER STATE permission for the login you are using. Many DBAs just logon with an account that has system administrator rights, so they have no problems running DMV queries.  If you want to write a Windows or Web… Read more

3 comments, 455 reads

Posted in Glenn Berry's SQL Server Performance on 20 January 2010

Three Big Things That Got Me Here

I was tagged by Steve Jones in the meme that Paul Randal started a few days ago, so I need to tell my story to keep it going. It is interesting,but not terribly surprising that many SQL Server DBAs are ex-military, and that many of them got an early start… Read more

2 comments, 296 reads

Posted in Glenn Berry's SQL Server Performance on 19 January 2010

SQL Server 2008 SP1 Cumulative Update 6 Released

Microsoft has released Cumulative Update 6 (CU6) for SQL Server 2008 SP1, which you can request here. This is Build 2757, and it has 33 listed fixes, which mainly seem to be focused on replication, SSRS, and SSAS. They have also released CU9 for SQL Server 2008 RTM Read more

5 comments, 1,014 reads

Posted in Glenn Berry's SQL Server Performance on 19 January 2010

A Few Useful Queries for SQL Server 2008 Integrated Full Text Search (iFTS)

I had a hardware issue this past weekend on one of my database servers where I am running SQL Server 2008 Integrated Full Text Search (iFTS). After the issue was resolved, I noticed a problem with iFTS, where changed items in the base relational tables were not being added to… Read more

0 comments, 936 reads

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

Intel Nehalem-EX and Database Performance

Intel is talking about the upcoming launch of the next generation Intel Xeon processor (Nehalem-EX) being bigger than the Xeon 5500 (Nehalem-EP). They are claiming greater than nine times the memory bandwidth compared to the six-core Xeon 7400 Dunnington series, and they are talking about getting three times the number… Read more

0 comments, 408 reads

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

The Energy Detective TED 5000 Installed And Working

Back in October, I ordered one of the new TED 5000 energy monitors directly from Energy, Inc. in Charleston, SC. It finally arrived this week (it was backordered), and I took advantage of the warm weather in Parker today to get it installed.  This unit uses two inductive pickups to… Read more

4 comments, 240 reads

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

Second Shot Promotion For Microsoft Certification Exams

Microsoft and Prometric have renewed their Second Shot promotion for certification exams. This allows you to retake a failed exam a second time for free, (which is pretty good insurance since the regular exam fee is $125.00). You can get the details here.

You might not know that failed… Read more

1 comments, 432 reads

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

PASS 2009 Speaker Evaluation Scores

Since quite a few PASS 2009 speakers have gone public with their speaker evaluation scores, I might as well do the same.  Session attendees were asked to rate the speaker and session in six areas, with a rating of Excellent = 5, Good = 4, Average = 3, Poor =… Read more

0 comments, 349 reads

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

Using Synthetic Benchmarks To Help Evaluate Database Server Hardware Choices

As a DBA, I think it is very important to stay current on trends in x64 based hardware. The DBA is much closer to the hardware than many other I.T. Professionals, and improperly chosen and sized hardware can cause lots of pain for both the DBA and everyone who depends… Read more

0 comments, 411 reads

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

Installing SQL Server 2008 and 2008 R2 on Windows Server 2008 R2

There is a recent post on the Microsoft SQL Server Support Blog about how to get SQL Server 2008 and 2008 R2 installed on Windows Server 2008 R2. The issue is how you get the .NET Framework 3.5 SP1 installed (which is a prerequisite for both SQL Server 2008 and…

Read more

3 comments, 787 reads

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

Intel Intelligent Home Energy Management

Last week at CES 2010, Intel showed off a proof of concept device for a home energy management dashboard. This device includes a programmable thermostat, weather information, energy monitoring and reporting, a motion sensor, video camera and stereo speakers, wi-fi support, an open API, Zigbee support, etc. It is… Read more

2 comments, 439 reads

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

Kevin Cox from SQLCAT Presenting at the Denver SQL Server User’s Group On January 21, 2010

Kevin Cox, who is part of the SQLCAT Team at Microsoft, will be giving the presentation at this month’s Denver SQL Server User’s Group meeting. He will be talking about the largest deployments on SQL Server, how they scale, how they achieve high availability and disaster recovery.  The talk will… Read more

0 comments, 410 reads

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

New HTPC Build with 32nm Intel Core i3 530

Since Intel announced and released the new 32nm Core i3 processors and compatible H55 chipset, Socket 1156 motherboards this week, I decided it was time to rebuild the home theater PC (HTPC) that is in my family room. The Core i3 processor is a dual-core, with hyper-threading (so the OS… Read more

0 comments, 1,233 reads

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

Time to Upgrade from SQL Server 2005 SP2 and SQL Server 2008 RTM

Microsoft’s Bob Ward posted to remind everyone that SQL Server 2005 SP2 support ends on January 12, 2010, and SQL Server 2008 RTM support ends on April 13, 2010. This means you need to get on SQL Server 2005 SP3 or SQL Server 2008 SP1. If I was still running… Read more

1 comments, 317 reads

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

How to Read the Results of SELECT @@VERSION in SQL Server

The simple query SELECT @@VERSION can quickly tell you quite a bit about a SQL Server installation (and the underlying operating system), assuming you know how to read the results correctly. Many people seem to get confused between the operating system information and the SQL Server information that this query… Read more

7 comments, 2,212 reads

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

Early Reviews of New Intel 32nm Desktop and Mobile CPUs

Well, now that the holidays are over and the Consumer Electronics Show (CES) is nearly upon us, we are starting to see quite a bit of information leak out regarding new laptops and desktops from all the first tier manufacturers. Many of these new models will be sporting one of… Read more

0 comments, 246 reads

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

Older posts