I am a newbie in SQL DBA. The background is SQL SERVER 2005 Pack4, running SQL Server Management Studio as an adming with 5 databases inside a single instance.
To sort out corruption with Object Plans, SQL Plans, Bound Trees, I executed DBCC FREEPROCCACHE and 'DBCC FREESYSTEMCACHE' without adding more instructions.
Now my laptop is stucked for yet 2 hours and the mouse & keyboard don't respond anymore.
I found out on other websites that cleaning all the cache should not be done if you don't know what you are doing, and that it will seriously affect performance but it was too late.
Two questions: 1) What should I do with a blocked PC for 2 hours? 2) Will the cache be rebuilt automatically and after some time perform again ? 3) What should I do to recover the performance I had before the caches were deleted?
Thanks in advance.
Aucun commentaire:
Enregistrer un commentaire