Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Group membership results in slow query result Expand / Collapse
Author
Message
Posted Tuesday, October 30, 2012 3:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 01, 2012 4:46 AM
Points: 1, Visits: 17
We are running a client application from which the query gives back results very slow or it times out if an ordinary user runs it, these users are all member of a domain group and the sql role of this group is public.
Whenever we run the same application from the same workstation as the domain admin which has a direct login on the sql server it gets its results within two or three seconds.
What could be the issue here?

Regards Peter.
Post #1378622
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse