DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2588453 - Last Review: August 22, 2011 - Revision: 1.0

On This Page

Microsoft distributes Microsoft SQL Server 2008 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release.

SYMPTOMS

Consider the following scenario:
  • You have a table that has a spatial data type column in Microsoft SQL Server 2008.
  • An index for the spatial data type column exists.
  • A query references the spatial data type column in the workload that is used by Database Tuning Advisor (DTA).
In this scenario, an access violation might occur in the SQL Server engine. The connection that DTA uses to handle the workload is automatically closed. Additionally, the following error message is logged in SQL Server error log:
<Date> <Time> spid#  SqlDumpExceptionHandler: Process# generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

RESOLUTION

Service pack information for SQL Server 2008

To resolve this issue, obtain the latest service pack for SQL Server 2008. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

968382  (http://support.microsoft.com/kb/968382/en-US/ )  How to obtain the latest service pack for SQL Server 2008


WORKAROUND

To work around this issue, use one of the following methods:
  • Disable or drop the spatial index on the spatial data type column and rebuild the index after the DTA analysis is finished.
  • Remove the query that references the spatial data type columns and that references the spatial data type indexes in the workload that is used by DTA.
Note By design, DTA does not recommend spatial indexes on spatial columns for tables.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about the DTA utility, visit the following MSDN website:

General information about the DTA utility (http://msdn.microsoft.com/en-us/library/ms162812.aspx)


APPLIES TO
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Enterprise Evaluation
Keywords: 
kbqfe kbfix kbexpertiseadvanced kbsurveynew KB2588453
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support