Welcome to MSDN Blogs Sign in | Join | Help

March 2009 - Posts

Tuesday, March 31, 2009 8:00 PM

SQL 2005: SQL Server Configuration Manager Error: Connection to target machine could not be made in a timely fasion.

There is a bug with the message spelling (fasion instead of fashion) but that is not the focus of this post. When launching the SQL Server Configuration Manager you may receive this message if the WMI connections and queries do not complete within 30
Posted by psssql | 1 Comments
Filed under: , , ,
Monday, March 30, 2009 12:38 AM

SQLDumper unable to generate mdmp files in SQL Server 2008 Failover clusters

SQLDumper utility is used by various components of the product to generate and save diagnostic information in the form of mini-dump and other log files. You will normally find the output files [with extension .mdmp, .txt and .log] created by sqldumper.exe
Posted by psssql | 1 Comments
Wednesday, March 18, 2009 11:18 PM

Parallel Index Creation performance issue

Both SQL Server 2005 and 2008 allow you to do parallel index creation. In fact you can specify MAXDOP in create index statement. When you use MAXDOP (let's say 8), you would assume that 8 threads will do equal amount of work and finish the work at the
Posted by psssql | 3 Comments
Filed under:
Tuesday, March 17, 2009 3:49 PM

SQL Server: What is a COLD, DIRTY or CLEAN Buffer?

Sent: Tuesday, March 17, 2009 2:05 AM Subject: what is clean buffer? what is cold buffer cache? I got these terms from DBCC DROPCLEANBUFFERS , please guide me.   ================================================================== From: Robert Dorr
Posted by psssql | 0 Comments
Filed under: , ,
Tuesday, March 17, 2009 3:38 PM

How It Works: What Are The Event Source Names Used By SQL Server

  Sent: Tuesday, March 17, 2009 4:24 AM Subject: Event Source changed from MSSQLServer to MSSQLSERVER to all upper case   Our different SQL server versions write to the Eventlog in a mixture of upper/lower case.  One version writes as Event
Posted by psssql | 1 Comments
Filed under: , , , ,
Tuesday, March 17, 2009 2:48 PM

How to fix your SQL Server 2008 Setup before you run setup (Part II)....

NOTE: Now updated for SQL Server 2008 SP1 RTM. Last year you might have read my post where I showed you how to patch setup for RTM for SQL Server 2008 before you launch setup . This processing involved installing a Cumulative Update to apply fixes for
Posted by psssql | 6 Comments
Friday, March 13, 2009 8:58 PM

SQL Server 2008 Ring Buffer Entries

Sent: Monday, March 09, 2009 6:20 PM Subject: Ring Buffers in SQL2008   Hi, do you have any documentation/white papers/examples about extended dmv’s or ring buffers in SQL2008? select distinct ring_buffer_type from sys . dm_os_ring_buffers
Posted by psssql | 1 Comments
Filed under: ,
Monday, March 09, 2009 2:49 AM

How to use computed columns to improve query performance

In general, you should avoid applying a scalar function on a column when comparing against another column, variable or constant. Let's use an example. Frequently, we got cases from customers who are not aware of performance implications and do just that.
Posted by psssql | 6 Comments
Filed under:
Thursday, March 05, 2009 10:21 PM

SocketException when creating a new Report Server Database

We had a customer call up that encountered a problem when trying to create a new database for their Report Server through the Reporting Services Configuration Manager.  This is what they saw: When we clicked on the Error link, we saw the following
Posted by psssql | 2 Comments
Wednesday, March 04, 2009 4:30 AM

Sparse File Errors: 1450 or 665 due to file fragmentation: Fixes and Workarounds

You might be familiar with the sparse file problem that Bob Dorr has blogged about in the past. http://blogs.msdn.com/psssql/archive/2008/07/10/sql-server-reports-operating-system-error-1450-or-1452-or-665-retries.aspx . We wanted to update you with the
Posted by psssql | 0 Comments
Tuesday, March 03, 2009 9:57 PM

How It Works: SQL Server - VDI (VSS) Backup Resources

Last week I worked on an interesting case.   The issue was a NT Backup against a single volume containing 500 SQL Server databases.  It is rare to have so many databases on a single volume but it is possible and we had a case on this very
Posted by psssql | 3 Comments
Tuesday, March 03, 2009 9:29 PM

Troubleshooting: SQL Server (2005, 2008) Performance Counter Collection Problems

I was asked by our support team to help outline performance counter troubleshooting when the counters don't appear, are missing or don’t seem to be working as expected.     I agreed to look into it and as you can see from the information
Posted by psssql | 3 Comments
Filed under: , ,
Tuesday, March 03, 2009 9:23 PM

How It Works: Almost Everything You Wanted To Know About The SQL Server (2005, 2008) Performance Counter Collection Components

I will be posting a troubleshooting companion to this 'How It Works' that outlines the associated troubleshooting steps for SQL Server base performance counter collection issues.    This post attempts to highlight the various components of the
Posted by psssql | 2 Comments
Filed under: , , ,
 
Page view tracker