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

Archives: June 2011

Performance Benefits of Adding RAM to a Laptop

I have a pretty nice Dell Latitude E6420 that I am using as a loaner laptop while I wait for my much nicer Dell Precision M4600 laptop to arrive. The E6420 has a Core i7-2720QM processor, but only had a single 4GB stick of DDR3 RAM installed.

The problem with… Read more

0 comments, 817 reads

Posted in Glenn Berry's SQL Server Performance on 30 June 2011

July 2011 Version of SQL Server 2008 Diagnostic Queries

Since July is only one day away, its time for the updated version of my SQL Server 2008 Diagnostic Information Queries. There is also an updated version of the results spreadsheet, with an additional tab for the latest new query in the set.

This new query lets you… Read more

2 comments, 762 reads

Posted in Glenn Berry's SQL Server Performance on 30 June 2011

CPU-Z 1.58 Released

Version 1.58 of the very useful utility CPU-Z was released on June 24, 2011. Originally (and still) popular for bragging rights in the PC hardware enthusiast community for proving how much you had been able to overclock a particular processor, it is actually very relevant in a professional I.T.… Read more

1 comments, 418 reads

Posted in Glenn Berry's SQL Server Performance on 27 June 2011

A Tale of Two Sandy Bridge Laptops

I recently bought a new teaching and presentation laptop, which is a Toshiba Portege R835-P55X, which I found at the Microsoft Store in Park Meadows Mall in Lone Tree, CO. This machine has a dual-core 2.3GHz Core i5-2410M, that also has Hyper-threading and Turbo Boost 2.0. It uses the… Read more

2 comments, 449 reads

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

Presenting Two Sessions at PASS Summit 2011

I found out earlier this week that I was fortunate enough to have my half day session on “Scaling SQL Server” accepted for the PASS Summit 2011, which was quite a pleasant surprise! I had previously been informed that I also had a 90 minute Spotlight Session… Read more

0 comments, 401 reads

Posted in Glenn Berry's SQL Server Performance on 19 June 2011

Three New TPC-E Submissions

I just noticed three very recent new TPC-E Benchmark Submissions that I thought were quite interesting. As I have written before, I think the TPC-E OLTP benchmark is a very useful tool for helping to make hardware selection and sizing decisions. It is especially relevant for SQL Server, since… Read more

0 comments, 470 reads

Posted in Glenn Berry's SQL Server Performance on 15 June 2011

Moving On To New Challenges

After nearly five and half years, I left NewsGator Technologies for a new position as a Database Architect at Avalara, in Bainbridge Island, Washington. My last day at NewsGator was June 3, 2011, and I started at Avalara on June 6, 2011.

NewsGator was a great experience for… Read more

4 comments, 351 reads

Posted in Glenn Berry's SQL Server Performance on 13 June 2011

June 2011 Version of SQL Server 2008 Diagnostic Queries

Since it is June, I thought it was time to update my SQL Server 2008 (and 2008 R2) Diagnostic Information Queries. This month has one new query, which rolls up total CPU usage by database for the current SQL Server instance. This can be useful if you are seeing signs… Read more

0 comments, 375 reads

Posted in Glenn Berry's SQL Server Performance on 2 June 2011

PASS Announces Pre-conference and Spotlight Sessions for PASS 2011 Summit

Today, PASS announced the Pre-conference and Spotlight Sessions for the PASS Summit 2011 in Seattle, which will run from October 11-14, 2011. I actually found out last week that I was lucky enough to be selected for a 90 minute Spotlight Session.

I am still amazed that I am on… Read more

0 comments, 389 reads

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