SQLDBA
Saturday, June 12, 2010
DBCC FLUSHPROCINDB(db_id);
Have you guys heard of this ?
To flush the cached procedure plans of a single DB
DBCC FlushProcINDB(db_id);
Complete Server:
DBCC FREEPROCCACHE
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment