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

Archives: November 2009

More News About AMD’s 2010/2011 Server Roadmap

AnandTech IT has an interesting post up that looks at the roadmap for AMD in the server arena for 2010/2011. The gist of it is that AMD may be competitive with Intel in some parts of the market (two-socket servers), which is very good news for the industry. If Intel… Read more

2 comments, 708 reads

Posted in Glenn Berry's SQL Server Performance on 30 November 2009

Teaching SQL Server 2008 Class at University of Denver – University College

I will be teaching ICT 4461 SQL Server with Lab starting Tuesday, January 5, 2010. This will be an on-campus class, held in the Josephine Computer Lab. The textbook is Beginning SQL Server 2008 for Developers by Robin Dewson. The ten week class is worth four units in the Master’s… Read more

1 comments, 720 reads

Posted in Glenn Berry's SQL Server Performance on 30 November 2009

SQL Server 2008 Diagnostic Information Queries (Late November 2009)

Here is the latest version of my Diagnostic Information Queries for SQL Server 2008.  Running these queries will give you a pretty good idea about the configuration and health of your server and about any particular databases on the server.

I have added several new queries this time, and tweaked… Read more

2 comments, 1,363 reads

Posted in Glenn Berry's SQL Server Performance on 24 November 2009

Some Intel Westmere Benchmarks

PCLab.pl has an interesting review and benchmarks of a 3.07GHz Westmere-EP processor (which is the six-core, 32nm successor to the Xeon 5500 series, Nehalem-EP processor).  This unit has six cores, and hyper-threading for a total of 12 cores per physical processor. The L3 cache is bumped up to 12MB.  This… Read more

0 comments, 308 reads

Posted in Glenn Berry's SQL Server Performance on 23 November 2009

Some Ways To Look For Things in SQL Server Modules

If you have a medium to large database in SQL Server, with lots of stored procedures, functions or views, it can sometimes be difficult to keep track of whether you have used certain options (such as RECOMPILE).  The queries below show some different things you can discover by querying sys.sql_modules… Read more

0 comments, 205 reads

Posted in Glenn Berry's SQL Server Performance on 23 November 2009

PDC 2009 Laptop Giveaway

During Steven Sinofsky’s keynote address at PDC09 today, he started telling a story about how some of the engineers in the Windows Division partnered with Acer to learn what a hardware manufacturer goes through when they design and configure a laptop computer. This story went on for several minutes, and… Read more

3 comments, 379 reads

Posted in Glenn Berry's SQL Server Performance on 19 November 2009

Impressions of PDC09 Day One

Back before I grew up and became a DBA, I used to be a developer.  This seems to be a fairly common career path for many DBAs that I have met. At any rate, I can relate to and understand developers somewhat better because I used to be one, and… Read more

0 comments, 194 reads

Posted in Glenn Berry's SQL Server Performance on 18 November 2009

Cumulative Update 5 For SQL Server 2008 Service Pack 1

Microsoft has released Cumulative Update 5 for SQL Server 2008 Service Pack 1.  You can go here to request the hotfix from Microsoft. It typically takes just a few minutes for them to send you the download link and password, then you have to download and unzip with the…

Read more

0 comments, 233 reads

Posted in Glenn Berry's SQL Server Performance on 17 November 2009

SQL Server 2008 iFTS Lessons Learned

We have been using SQL Server 2008 Integrated Full Text Search (iFTS) in Production at NewsGator for a little over a year, with very good results. We were able to replace a 3rd party solution that required a lot of attention, maintenance, and extra hardware, with a very simple iFTS… Read more

0 comments, 390 reads

Posted in Glenn Berry's SQL Server Performance on 17 November 2009

SQL Server MVP Deep Dives Book Signing At PASS Summit

Kimberly Tripp posted today about the SQL Server MVP Deep Dives book signing event at PASS on November 4. The PASS bookstore sold out of all of their copies of the book (150 in all), and many people who bought the book waited patiently in a long line to have… Read more

1 comments, 274 reads

Posted in Glenn Berry's SQL Server Performance on 17 November 2009

Using Dedicated NICs to Segregate SQL Server 2008 Backup Traffic

If you need to initialize a mirrored database for SQL Server 2008 Database Mirroring, one of the first things you have to do is take a full backup of the database that you want to mirror. You can either back it up locally and copy the backup file(s) over the… Read more

0 comments, 817 reads

Posted in Glenn Berry's SQL Server Performance on 14 November 2009

SQL Server 2008 Database Mirroring in Action

I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800 and four Dell PowerEdge 1950 servers that were running a number of busy, large SQL Server 2008 databases. We had previously done some vertical partitioning (splitting different application functionality across… Read more

5 comments, 697 reads

Posted in Glenn Berry's SQL Server Performance on 13 November 2009

Windows Virtual PC and Windows XP Mode on Windows 7

One feature of Windows 7 that you may not have heard of is Windows XP Mode on Windows Virtual PC. These allow you to use hardware assisted virtualization (if your processor supports it, and you have it enabled in your BIOS) to run guest operating systems. Windows XP Mode… Read more

1 comments, 725 reads

Posted in Glenn Berry's SQL Server Performance on 12 November 2009

New HP Envy 15 Laptop

After quite a bit of research, I pulled the trigger on a new HP Envy 15 system last Saturday. This system has a 1.6GHz Core i7 Q720, 6GB of RAM, a 7200rpm 500GB drive and an ATI HD Radeon 4830 with 1GB of video memory. The max screen resolution is… Read more

8 comments, 960 reads

Posted in Glenn Berry's SQL Server Performance on 12 November 2009

SQL Server 2005 Diagnostic Information Queries

Here is an updated version of my diagnostic information queries for SQL Server 2005. You can get the SQL Server 2008 version here. Most of the DMV queries require VIEW SERVER STATE permission.

-- SQL Server 2005 Diagnostic Information Queries
-- Glenn Berry 
-- November 2009
-- http://glennberrysqlperformance.spaces.live.com/
--…

Read more

2 comments, 727 reads

Posted in Glenn Berry's SQL Server Performance on 9 November 2009

Temporary Post Used For Theme Detection (3d1489bf-65cc-47a0-b394-b28676998db9 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (e29f86d1-0b33-4a68-adcd-77248245d9b5 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)

Read more

0 comments, 248 reads

Posted in Glenn Berry's SQL Server Performance on 9 November 2009

SQL Server Wait Type Repository

Microsoft’s Bob Ward has a good post up on the CSS SQL Server Engineers blog about an upcoming web page that will completely document all of the wait types from the sys.dm_os_wait_stats DMV. There will be more detailed and practical information about the individual wait types compared to what… Read more

0 comments, 456 reads

Posted in Glenn Berry's SQL Server Performance on 8 November 2009

Worldwide Operating System Market Share for October 2009

Ars Technica has a good post up showing that Windows 7, (which has been out for two weeks) has already passed Snow Leopard and Linux in market share.  Windows 7 is really a nice operating system that you quickly grow very used to in daily use. All my machines at… Read more

0 comments, 703 reads

Posted in Glenn Berry's SQL Server Performance on 7 November 2009

SQL Server 2008 R2 Running on “Big Iron”

During the opening keynote on Tuesday at the PASS Summit in Seattle, Microsoft’s Bob Muglia showed a demonstration of a pre-release build of SQL Server 2008 R2 Datacenter Edition on Windows Server 2008 R2.

The demo started out with 64 processor cores running at about 90%. Bob pushed a button,… Read more

0 comments, 565 reads

Posted in Glenn Berry's SQL Server Performance on 5 November 2009

New Pricing and Editions For SQL Server 2008 R2

Mary-Jo Foley recently posted about some announcements about SQL Server 2008 R2 out of the PASS Summit. There will be two new, high-end SKUs of SQL Server 2008 R2, and the prices of Standard and Enterprise Edition are going to be increased somewhat over SQL Server 2008.

Standard: $7,500…

Read more

0 comments, 378 reads

Posted in Glenn Berry's SQL Server Performance on 5 November 2009

Older posts