I have a Server with SQLServer 2005 64 bit and I installed SQL Server 2008 R2 64bit and I moved the Databases and logins to SQL Server 2008 R2.After that (to night) I ran Integrity check + rebuild index + update statistics jobs.
after that I found SQL Server consumed more memory and not released.what was the reason behind and how to clean that memory.
Please guide with query or with an idea, your help is greatefull for me.
Thanks in Advance
View Complete Post