Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Reports Running Slow

Author  Topic 

dbalearner
Constraint Violating Yak Guru

272 Posts

Posted - 2012-11-22 : 17:10:24
The Reporting is done on accessing from Data server through the reporting Server and clients complained of reports being slow.

I have checked from the 'sys.dm_os_memory_clerks' View and found 'TokenAndPermUserStore' type has been freed up even then Users unable to expedite their reports to their satisfcation.

Can anyone tell what and where should this problem be looked into, and other areas.

Thanks All.
   

- Advertisement -