Sign in
Home
Microsoft Blog Images
More ...
CSS SQL Server Engineers
This is the official team Web Log for Microsoft Customer Service and Support (CSS) SQL Support. Posts are provided by the CSS SQL Escalation Services
MSDN Blogs
>
CSS SQL Server Engineers
Common Tasks
Blog Home
Email Blog Author
RSS for Comments
RSS for Posts
Atom
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Search
Tags
2005
2005 SP2
2008
2008 R2
Adam
Connectivity
Engine
How It Works
Memory
Patching
Performance
READTRACE
Reporting Services
RML Utilities
Setup
SQL 2005
SQL Server 2005 SP2
SQL Server 2008
SQL Server 2008 SP1
SQLOS
Tools
Trace
Tracing
Troubleshooting: The DB Engine
Windows 2008
Archives
Archives
September 2010
(1)
August 2010
(7)
July 2010
(7)
June 2010
(7)
May 2010
(8)
April 2010
(7)
March 2010
(4)
February 2010
(5)
January 2010
(5)
December 2009
(9)
November 2009
(6)
October 2009
(4)
September 2009
(9)
August 2009
(5)
July 2009
(8)
June 2009
(9)
May 2009
(12)
April 2009
(8)
March 2009
(13)
February 2009
(14)
January 2009
(13)
December 2008
(8)
November 2008
(9)
October 2008
(3)
September 2008
(9)
August 2008
(10)
July 2008
(7)
June 2008
(4)
May 2008
(1)
April 2008
(11)
March 2008
(10)
February 2008
(6)
January 2008
(10)
December 2007
(1)
November 2007
(1)
October 2007
(2)
September 2007
(2)
August 2007
(2)
June 2007
(2)
May 2007
(1)
April 2007
(2)
March 2007
(2)
February 2007
(7)
January 2007
(2)
December 2006
(4)
November 2006
(9)
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
CSS SQL Server Engineers
Slow query performance because inaccurate cardinality estimate when using anti-semi join following upgrade from SQL Server 2000
Posted
Wed, Sep 1 2010
by
Jack Li
2
Comments
We have a few customers who reported that some of their queries run slower following upgrade from SQL Server 2000 to SQL Sever 2005, 2008 and 2008 R2. Specifically, queries experiencing the issue have anti-semi joins in the query plan and the join involves...
CSS SQL Server Engineers
Query performance and table variables
Posted
Tue, Aug 24 2010
by
Jack Li
0
Comments
Technorati Tags: Performance Frequently, we see our customers using table variables in their stored procedures and batches and experience performance problems. In general, these performance problems are introduced because of large number of...
CSS SQL Server Engineers
Why use SQL Server 2008 R2 BPA? Case 1: Missing Updates…..
Posted
Tue, Aug 24 2010
by
psssql
1
Comments
In June I introduced you to a new Best Practices Analyzer for SQL Server, SQL Server 2008 R2 BPA: http://blogs.msdn.com/b/psssql/archive/2010/06/20/introducing-the-sql-server-2008-r2-best-practices-analyzer-bpa.aspx I’ve seen some mixed reaction to this...
CSS SQL Server Engineers
How It Works: Timer Outputs in SQL Server 2008 R2 - Invariant TSC
Posted
Wed, Aug 18 2010
by
psssql
1
Comments
I would love nothing more than to take you back to my high-school days running the 440 yard hurdles (yes yards not meters) where timing was done with a stop watch (you know the old, moving dial style) but timers on the PC don't allow that simplicity....
CSS SQL Server Engineers
How It Works: Enumeration of sys.messages
Posted
Mon, Aug 16 2010
by
psssql
1
Comments
I ran into an issue which has some aspects I found interesting and thought you might as well. When you do a select against the sys.messages virtual table the data is retrieved from the resource files (.RLL) files stored under <<Instance>>...
CSS SQL Server Engineers
Replay Result Set Event (Replay * Events)
Posted
Fri, Aug 13 2010
by
psssql
0
Comments
From: Robert Dorr Sent: Friday, August 13, 2010 8:58 AM Subject: RE: SQL Server Trace Replay - "Replay Result Set Event" The Result Set event is one of several client side replay events. Here are some of Common Result Event Columns Text Returned values...
CSS SQL Server Engineers
When a full dump isn’t really a full dump…
Posted
Wed, Aug 4 2010
by
Adam W. Saxton
0
Comments
I was working on a customer issue which involved debugging a dump. The dump was generated via SQLDumper within Reporting Services. So, the name of the dump was similar to SQLDmpr0001.mdmp. When I opened the dump I saw the following:...
CSS SQL Server Engineers
How It Works: Error 18056 - The client was unable to reuse a session with SPID ##, which had been reset for connection pooling
Posted
Tue, Aug 3 2010
by
psssql
3
Comments
This message has come across my desk a couple of times in the last week and when that happens I like to produce blog content. The error is when you are trying to use a pooled connection and the reset of the connection state encounters an error. Additional...
CSS SQL Server Engineers
SQL 2008 FileStream Fails to Enable After Setup on Cluster that uses Veritas Mountpoints
Posted
Thu, Jul 29 2010
by
psssql
0
Comments
Recently a customer ran into an issue where they had successfully installed SQL Server 2008 SP1 on a 2 node Windows 2008 cluster. When they went to restore a database that was given to them, they found out the database was created with the new SQL 2008...
CSS SQL Server Engineers
Installing SQL Integration Services after SQL Cluster Setup has Completed
Posted
Thu, Jul 29 2010
by
psssql
0
Comments
Today I ran into an issue where, SQL Server 2008 SP1 was installed on a Windows 2008 cluster and was working just fine, but we wanted to install SQL Server Integration Services (SSIS) to the two nodes of the cluster. Since SSIS is not cluster aware, we...
CSS SQL Server Engineers
Why does PREEMPTIVE_OS_GETPROCADDRESS Show a Large Accumulation?
Posted
Wed, Jul 21 2010
by
psssql
2
Comments
There is a bug in SQL Server 2008 that causes PREEMPTIVE_OS_GETPROCADDRESS to include and accumulate the execution time of the extended stored procedure (XPROC) . The following is an example showing the increase in the GetProcAddress wait time. select...
CSS SQL Server Engineers
Sampling can produce less accurate statistics if the data is not evenly distributed
Posted
Fri, Jul 9 2010
by
Jack Li
1
Comments
Recently I worked with a very knowledgable customer who called in and wanting to know things about statistics. This is because he noticed that his query would get inaccurate cardinality estimate due to ‘inaccurate histogram. ...
CSS SQL Server Engineers
Why is my SQL Clustered Instance changing authentication modes?
Posted
Fri, Jul 9 2010
by
psssql
3
Comments
We get our fair share of cases related to SQL Server running ( or not running) on a Windows Cluster. I had one of them recently where the customer was seeing different authentication modes for SQL Server depending on which node of the 2-node cluster...
CSS SQL Server Engineers
Why doesn't SQL Server use statistics and index on this computed column?
Posted
Thu, Jul 8 2010
by
psssql
1
Comments
In this post , I talked about how to use computed column to improve performance. By creating index on a computed columns, you can have two benefits. You get better cardinlaity esimate on the expression in your query and your query may also use that index...
CSS SQL Server Engineers
Revisiting an old SSRS performance topic again…
Posted
Sun, Jul 4 2010
by
psssql
2
Comments
Almost three years ago, I posted about why Reporting Services takes so long to respond to the first request if it has been sitting idle for a long time (like overnight). The original post can be found at http://blogs.msdn.com/b/sqlblog/archive/2007...
CSS SQL Server Engineers
My Kerberos Checklist…
Posted
Wed, Jun 23 2010
by
Adam W. Saxton
7
Comments
I’ve had numerous questions regarding Kerberos, both internally within Microsoft and with Customers. It continues to be a complicated topic and the documentation that is out there can be less than straight forward. Based on some previous items...
CSS SQL Server Engineers
Known issues installing SQL 2008 R2 BPA relating to Remoting
Posted
Mon, Jun 21 2010
by
Adam W. Saxton
5
Comments
After getting through the Pre-Reqs for BPA (PowerShell 2.0, MBCA, .NET Framework), you may hit one of two scenarios when installing BPA. In all of the cases of an install failure, you will see the following error: “There is a problem with this Windows...
CSS SQL Server Engineers
Introducing the SQL Server 2008 R2 Best Practices Analyzer (BPA)…
Posted
Sun, Jun 20 2010
by
psssql
9
Comments
Some of you may have noticed I haven’t posted a blog in some time. Well, I’ve been a bit busy working behind the scenes on a new tool we released this weekend, the SQL Server 2008 R2 Best Practices Analyzer (BPA). You may remember that I announced this...
CSS SQL Server Engineers
Where did the SQL Server Instance disappear? The clue may be in the WMI logs!
Posted
Sat, Jun 12 2010
by
psssql
0
Comments
We recently worked with a customer who ran into an interesting situation. This problem deals with SQL Server 2005 Service Pack 3 setup. Normally, when you launch the SQL 2005 SP3 setup and you reach the screen which shows the components for which you...
CSS SQL Server Engineers
How It Works: SqlDataReader::RecordsAffected and Why it Returns -1
Posted
Tue, Jun 8 2010
by
psssql
0
Comments
I encountered another interesting research issue to share with you. The documentation states RecordsAffected are for INSERT, UPDATE and DELETE but it might fool you. ------------------------------------------------------------------------------------...
CSS SQL Server Engineers
SQLIOSim - Is Error: Unable to get disk cache info really an error?
Posted
Tue, Jun 8 2010
by
psssql
0
Comments
The short answer is that it is not an error and the message should be a WARNING. I looked at the latest, internal code base it has already been changed to a WARNING. if (!DeviceIoControl (volume, IOCTL_DISK_GET_CACHE_INFORMATION, NULL, 0, &m_diskCacheInfo...
CSS SQL Server Engineers
How It Works: Spinlock Of Type LPE_BATCH
Posted
Tue, Jun 8 2010
by
psssql
0
Comments
A question arose asking - "What does the LPE_BATCH spinlock type represent?" You can see the LPE_* series of spinlocks using the DMV query " select * from sys . dm_os_spinlock_stats " A spinlock is a lightweight, user mode synchronization object used...
CSS SQL Server Engineers
Don’t touch that schema!!!
Posted
Sun, May 30 2010
by
psssql
4
Comments
You know how every product that has an underlying database has documentation that says not to modify the schema? Do you always pay attention to that warning? If your product is Reporting Services, I just ran into a case today which I hope convinces...
CSS SQL Server Engineers
SQL Server 2008 R2 New Non-Yield Ring Buffer Information
Posted
Thu, May 27 2010
by
psssql
0
Comments
In 2002 the SQLOS team added specific checks for non-yielding scheduler issues. You may be familiar with the 178** series of errors like 17883 scheduler non-yield. Since 2002 the test matrix for SQL Server has flagged these errors and corrected them....
CSS SQL Server Engineers
How It Works: The SQLAgent Log File
Posted
Thu, May 27 2010
by
psssql
1
Comments
I am still working to resolve the customers problem but during my investigation I briefly looked a the SQLAgent logging format and thought you all might like some of these details. From: Robert Dorr Sent: Monday, May 24, 2010 9:47 AM Subject: RE: SPID...
Page 1 of 12 (286 items)
1
2
3
4
5
»