Clear SQL Server Cache

When perform benchmark testing, make sure you need to clean the SQL server cache in order to have a more accurate result.

-- Clean all data in the cache
DBCC DROPCLEANBUFFERS

-- clean cache from stored procedure
DBCC FREEPROCCACHE

Comments

Post a Comment

Popular posts from this blog

Error 401.1 "Unauthorized: Access is denied due to invalid credentials"

Have developed a ASP.NET application, in which it will call a web service from another web application but within the same IIS server. Everything is fine until putting those into production server. The web service requires Windows authentication.  Error 401.1 "Unauthorized: Access is denied due to invalid credentials" occur even we pass the correct user name, password.  We ensure the account is not locked. After Googling, we found that it happens on Windows 2003 Server SP1, IIS6 with integrated authentication enabled. http://support.microsoft.com/kb/896861 Above KB describe the solution about the loopback issue, I am not repeating there.  The most important thing is it happens to some host name only, not all. After we do some testing, we find that if the host name is CNAME in our DNS, it works.  But if we set to A (IP address), then no luck. Example: name1.mydomain.com -> WEBSERVER01.LOCAL (CNAME) name2.mydomain.com -> 192.168...
Read more

SQL Server 2005: MUST_CHANGE is ON

I have created a SQL user, but it force me to change to password. I go to the SQL Server Management Studio and untick the Enforce password policy. However it prompt the following message: The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON (Microsoft SQL Server, Error: 15128) A SQL query can solve the problem ALTER LOGIN (Username here) WITH PASSWORD = '(Password here)'
Read more