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

Archives: December 2009

A Small Collection of I/O Specific DMV Queries

It is pretty common for large, busy SQL Server implementations to run into I/O pressure or bottlenecks, especially since many people seem to buy “big” servers with lots of CPU capacity and lots of RAM, but they treat the I/O subsystem as an afterthought. I have run into this situation… Read more

2 comments, 2,207 reads

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

Windows ReadyBoost in Windows 7

Perhaps you heard of or actually tried Windows ReadyBoost in Windows Vista, and were (like me) disappointed with the results? The idea behind ReadyBoost is to take advantage of flash memory as a cache for random disk I/O. Microsoft made some improvements to Windows ReadyBoost in Windows 7, which… Read more

7 comments, 1,267 reads

Posted in Glenn Berry's SQL Server Performance on 29 December 2009

Fun With DBCC FREEPROCCACHE

Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some sort of a scary warning about how you should not use it on a production system, or else life as we know it will end. For example, Books Online says… Read more

18 comments, 11,252 reads

Posted in Glenn Berry's SQL Server Performance on 28 December 2009

How To Get a Count of SQL Connections BY IP Address

These queries (which work on both SQL Server 2005 and 2008) are very handy if you want to know who is connecting to a SQL Server instance and how they are doing it.  It will give you a nice idea how your application or web servers are behaving in terms… Read more

28 comments, 2,378 reads

Posted in Glenn Berry's SQL Server Performance on 28 December 2009

Should You Get a Netbook Computer?

On Monday, Intel officially announced the next generation Atom processors (aka Pineview) that are part of the new Pine Trail platform. According to AnandTech, these new Atoms offer about 5-10% better performance along with 15-20% better battery life. If you have an Atom N270 or N280 based netbook, you… Read more

1 comments, 240 reads

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

Two Tools For Discovering Hardware Information About Your Servers

One thing that I think is very important for a successful DBA to be aware of is their hardware environment.  Database servers typically place more demands on their hardware resources than the more common web or application server, and if a database server is under pressure, it can cause lots… Read more

0 comments, 566 reads

Posted in Glenn Berry's SQL Server Performance on 21 December 2009

Great Resource On SQL Server Wait Types

Microsoft's Bob Ward has updated his blog post about documenting SQL Server wait types, that came out of his work at PASS 2009. He is planning on updating his post further as he gets comments and questions on his blog.

You can query your SQL Server 2005/2008 instance to get…

Read more

0 comments, 463 reads

Posted in Glenn Berry's SQL Server Performance on 21 December 2009

Webcast: SQL Server 2008 R2 Support for Up to 256 Logical Processors

If you are a low-level, bare-metal type of SQL Server geek, you will probably enjoy watching this 60 minute webcast by Microsoft’s Madhan Arumugam and Fabricio Voznika. It has a lot of interesting and useful information on how Microsoft was able to scale up beyond 64 logical processors to 256… Read more

0 comments, 345 reads

Posted in Glenn Berry's SQL Server Performance on 21 December 2009

Cumulative Update 7 For SQL Server 2005 SP3

Microsoft has announced the release of CU7 for SQL Server 2005 SP3, which is Build 4273. The link to request the CU from Microsoft is not live yet, but should be pretty soon, hopefully.  I count 23 fixes included in this release.

Read more

2 comments, 220 reads

Posted in Glenn Berry's SQL Server Performance on 21 December 2009

Cumulative Update 17 For SQL Server 2005 SP2

Microsoft has announced the release of CU17 for SQL Server 2005 SP2, which is Build 3356. The link to request the CU from Microsoft is not live yet, but should be pretty soon hopefully.  I only see one fix (for MDX) included in this release.

Read more

0 comments, 249 reads

Posted in Glenn Berry's SQL Server Performance on 21 December 2009

How to Copy Query Results From SQL Server 2005/2008 into Excel

I often work with DBAs who need to copy the results of a T-SQL query from SQL Server Management Studio (SSMS) into some portable format that is easy to save and comprehend. The easiest way that I have found is to right-click on the top left grid cell and choose… Read more

4 comments, 3,217 reads

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

Updated SQL Server 2008 Diagnostic Queries

Here is the mid-December version of my diagnostic queries for SQL Server 2008. The idea here is to be able to easily and quickly gather quite a bit of information about your database server instance and individual databases on that instance that can help you detect many SQL Server configuration… Read more

0 comments, 532 reads

Posted in Glenn Berry's SQL Server Performance on 16 December 2009

More Information about Intel Desktop CPU Roadmap

Endgadget has a post up about an upcoming 32nm Westmere family CPU called the Core i7-980X, which will have six cores (12 with hyper-threading), 12MB of shared L3 cache, clocked at 3.33GHz. It will be an “Extreme Edition” processor, which means that you would have to be extremely foolish to… Read more

2 comments, 271 reads

Posted in Glenn Berry's SQL Server Performance on 15 December 2009

Some SQL Server 2005/2008 Monitoring Stored Procedures

Here is a collection of five stored procedures that are very useful for monitoring the overall health of a SQL Server 2005/2008 instance. These are instance level queries, not database level queries. They are very easy to periodically call from a Windows or Web client to display these items:

Average…

Read more

0 comments, 612 reads

Posted in Glenn Berry's SQL Server Performance on 11 December 2009

Old DBA Trick To Confirm SQL Server Connectivity

“What’s wrong with the database?" or “I can’t connect to SQL Server”  How many times have you heard phrases like that from your developers and QA people? Remember, DBA means “default blame acceptor”, or guilty until proven innocent. I am going to show you how to prove yourself (and SQL… Read more

3 comments, 392 reads

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

Microsoft Creates Server and Cloud Division

Microsoft announced today that they are reorganizing and combining the existing Windows Server and Solutions Group and the Windows Azure Group into a new Server & Cloud Division (SCD) that will all be in the Servers and Tools Division, led by Bob Muglia.

Mary Jo Foley has her take on… Read more

0 comments, 312 reads

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

Microsoft Certified Master: SQL Server 2008 Pre-reading List

Via Twitter, I stumbled upon a link to this newly updated pdf from Joseph Sack and David Ikeda who are instructors for the Microsoft Certified Master: SQL Server 2008 program at Microsoft. I have previously written about the program here. The executive summary is that it is a very… Read more

2 comments, 367 reads

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

Microsoft Student Career Portal

Microsoft Learning has put up a new Microsoft Student Career Portal that gives advice and links to resources on how students can prepare themselves for careers as Database Administrators, Server Administrators, Consumer Support Technicians, Web Developers and Windows Developers. Each job role has a Student Learning… Read more

0 comments, 479 reads

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

Micron Real SSD C300

Endgadget recently had a post up about the Micron Real SSD C300 family of SATA 6Gbps SSDs that will be available in 128GB and 256GB sizes early next year. Micron has several videos up on their blog that show how a system with this drive performs compared to a standard… Read more

3 comments, 300 reads

Posted in Glenn Berry's SQL Server Performance on 4 December 2009

Fun With SQL Azure

Pinal Dave had a helpful post a few days ago about how to setup and configure SQL Azure. You will need a Windows Live ID, and an Invitation Code before you can configure SQL Azure.

Once you have configured SQL Azure and created a database, you can register your… Read more

0 comments, 685 reads

Posted in Glenn Berry's SQL Server Performance on 3 December 2009

Older posts