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

Archives: November 2009

Day 1 At SQL PASS in Seattle

Today was my big, somewhat stressful day at the PASS summit in Seattle. I gave two, 75-minute Community session  presentations, one on SQL Server 2008 Full Text Search at 10:15AM, and the other on DMV queries at 1:30PM. In between, I hosted a Birds of a Feather table at lunch… Read more

2 comments, 502 reads

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

SQL Server 2008 Diagnostic Information Queries

Here is the script that I used in my Dr. DMV presentation this afternoon at PASS. It is a set of pretty heavily commented queries that are very useful for detecting and diagnosing many common performance issues with SQL Server 2008.

-- SQL Server 2008 Diagnostic Information Queries
-- Glenn…

Read more

5 comments, 636 reads

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

Basic iFTS Monitoring Queries

This is one of the scripts that I will be using for my presentation “Tips and Tricks for Using SQL Server 2008 Integrated Full Text Search in a High Volume OLTP Environment” at 10:15-11:30AM in Room 608 at SQLPASS on Tuesday, November 3. There are so many good… Read more

1 comments, 635 reads

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

Minor Setup Issue with SQL Server 2008 or SQL Server 2008 R2 on Windows 7

Microsoft’s Peter Saddow, who is a Program Manager on the SQL Server Setup team has a post in the SQL Server Setup blog that explains an occasional error that you can see when you install SQL Server 2008 or SQL Server 2008 R2 August CTP on Windows 7 that looks… Read more

0 comments, 135 reads

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

Two Very Important Configuration Settings For SQL Server 2005/2008

Two settings that I always enable when I install SQL Server 2005 or 2008 on an x64 production database server are “Lock pages in memory” and “Perform volume maintenance tasks”. These are actually User Rights Assignments in Windows that you grant to the SQL Server Service account in Local Group… Read more

3 comments, 2,576 reads

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

Newer posts