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

Archives: September 2010

Stupid Tech Support Tales

One of our desktop support technicians noticed the following error from a 3rd party vendor application in an error log:

"9/22/2010 1:02 AM (GMT-06:00): The xxxxx Maintenance Service has reported an error. (200) CCmd: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Our technician e-mailed the error message (along…

Read more

0 comments, 572 reads

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

Geekbench 2.1.7 Released

If you read my blog or follow me on Twitter, you know that I have a strong interest in database server hardware. Having properly selected and sized database server hardware gives you a strong foundation to architect and implement a scalable, high performance database solution. Of course, a bad… Read more

0 comments, 700 reads

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

A Small Selection of SQL Azure System Queries

I had a question come up during my “Getting Started with SQL Azure” presentation at SQLSaturday #52 in Denver last Saturday that I did not know the answer to. It had to do with how you could see what your data transfer usage was in and out of a SQL… Read more

0 comments, 569 reads

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

Windows Power Plans and CPU Performance

Back in February, 2010, I did some preliminary testing on the effects of various BIOS settings and Windows Power Plans on processor performance in Windows Server 2008 R2 using the cross-platform Geekbench benchmark. That round of testing used an 2.8GHz Intel Core i7 860 processor in an ASUS desktop board.… Read more

0 comments, 894 reads

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

SQLSaturday #52 Report

I was lucky enough to present two sessions at SQLSaturday #52 in Denver on September 25, 2010. By my estimate, there were probably between 200-250 attendees for the event. The event was well organized, with easy parking, plenty of food, and a smooth registration process. The session rooms were a… Read more

2 comments, 165 reads

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

SQL Server Quiz 2010

SQL Sever MVP Jacob Sebastian (blog/twitter) has been working hard to organize the SQL Server Quiz 2010 event which will be starting on October 1, 2010. This will be a series of 30 Quiz questions, presented each day by a “Quiz Master”, who will be in… Read more

2 comments, 340 reads

Posted in Glenn Berry's SQL Server Performance on 27 September 2010

Project Phoenix For Unemployed and Underemployed Developers

SQL Server MVP Arnie Rowland (blog/twitter) has put a lot of effort into conceiving, organizing, and publicizing Project Phoenix over the past several months. Just in case you have never heard of this effort, the gist of it is to reach out to unemployed/underemployed Developers and… Read more

0 comments, 195 reads

Posted in Glenn Berry's SQL Server Performance on 27 September 2010

Microsoft Releases SQL Server 2008 SP1 Cumulative Update 10

On September 21, 2010, Microsoft released SQL Server 2008 SP1 Cumulative Update 10, which is Build 2799. I count 29 fixes in this cumulative update. This fixes apply to lots of different areas of the product, including SSAS, SSIS, SSRS, Full-Text Search, and the Engine.

Read more

1 comments, 604 reads

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

What Do You Think Just Happened To This Database Server?

This is a screenshot of Task Manager for a database instance that is part of a synchronous database mirroring partnership in SQL Server 2008 R2. We are using synchronous database mirroring, with a Witness instance, so we have automatic failover. There are a number of mirrored, user databases that normally… Read more

0 comments, 490 reads

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

Home Theater Upgrades

Back in late 2003, I had my basement finished,and as part of that effort, I put in a dedicated home theater with a 105” 16x9 screen, an Infocus ScreenPlay 7200 720p DLP projector and 8.1 sound. This setup has worked very well over the years, but it is time for… Read more

0 comments, 177 reads

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

SQL Server 2008 and 2008 R2 Diagnostic Information Queries

Here is the latest version of my Diagnostic Information Queries for SQL Server 2008 and SQL Server 2008 R2. These are very useful for determining the configuration, health, and performance of a SQL Server instance and individual database.

I have added a couple of new queries, and added some more…

Read more

3 comments, 1,964 reads

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

SQL Saturday #52 in Denver

Its only about a week until SQL Saturday #52 in Denver. This is an all day, free event, being held at Cherry Creek Presbyterian Church 10150 E. Belleview Avenue Englewood, CO 80111. There are a number of great speakers, and lots of free loot to be given away. Read more

0 comments, 184 reads

Posted in Glenn Berry's SQL Server Performance on 17 September 2010

Hardware 201:Selecting and Sizing Database Hardware for OLTP Performance

I did a presentation for the fourth hour of 24 Hours of PASS – Fall 2010 today, which was a lot of fun. We had about 450 attendees for the session, which was a pretty decent turnout. A recording of the session will be available on September 27. I have… Read more

2 comments, 349 reads

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

Some Moderately Big Iron on x64

Here is a screenshot from a Dell PowerEdge R910 with four 2.27GHz Intel Xeon X7560 processors and 256GB of RAM. The Intel Xeon X7560 processor has eight cores, plus hyper-threading, for 16 logical cores per physical CPU. This gives you 64 logical processors for the entire machine. If you have… Read more

1 comments, 416 reads

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

Discount Code For SSWUG Ultimate Virtual Conference

If you are interested in watching some high quality SQL Server content from the comfort and convenience of your own computer, you should consider attending the SSWUG Ultimate Virtual Conference on October 20, 21, and 22. The are a number of high quality, well-known speakers, on a wide variety… Read more

0 comments, 202 reads

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