We are running production DB servers on SQL Server 2005 and we ran into high TokenAndPermUserStore issue which caused the delay in running queries. There is a scheduled job on the SQL server which runs every 1 hour and performs the DBCC FREESYSTEMCACHE (‘TokenAndPermUserStore’) however this job was hung for many hours and had to be eventually killed. What are the possible reasons that a DBCC FREESYSTEMCACHE gets hung for so long. Can the incoming queries cause it?
Aucun commentaire:
Enregistrer un commentaire