Slow performance with SQLServer 2008 upgrade

Topics: MMC SnapIn
Apr 28, 2011 at 6:21 PM

Hi,

We recently upgraded from SQLServer 2005 to 2008 on the same server box, and we are seeing very slow performance on the following select, resulting in timeouts in the MMC plugin. The slow response *only* happens for users who are NOT Administrators or db_owners. Under SQLServer 2005 the following select returns within less than a second. Under SQLServer2008 it was taking about 2 minutes. The DBAs updated all the statistics, but it is sill taking about 40 seconds.

Has anyone encountered any similar issues with SQLServer2008, or have any hints or ideas? (We are running NetSqlAzMan Version 3.5.4.2)

USE [SACAppAuthorization]
GO
SELECT [t0].[StoreId], [t0].[Name], [t0].[Description]
FROM [dbo].[Stores]()
AS [t0]

Thanks in advance,
Umesh Sood

Coordinator
Apr 29, 2011 at 6:04 AM

See if this can help:

http://blogs.technet.com/b/sqlos/archive/2008/07/18/debugging-slow-response-times-in-sql-server-2008.aspx

__________________________________
Andrea Ferendeles
NetSqlAzMan Project Coordinator
E-mail aferende@hotmail.com Web http://netsqlazman.codeplex.com