Script to free cache
Posted by Karthick P.K on December 6, 2010
DBCC FREESYSTEMCACHE ( 'ALL' ) WITH MARK_IN_USE_FOR_REMOVAL
GO
DBCC FREESESSIONCACHE WITH NO_INFOMSGS
GO
DBCC FREEPROCCACHE WITH NO_INFOMSGS
GO
DBCC DROPCLEANBUFFERS
GO
MSSQLWIKI
Karthick P.K on SQL Server
Karthick P.K
Subscribe
Visits
SQLSERVERSCRIBBLES.COM- Capture context switches from dm_os_ring_buffers May 15, 2013
- SSIS package fails when executed as job using proxy account May 7, 2013
- How to stimulate a SQL Server resource failure in cluster April 26, 2013
- Error 601 : Could not continue scan with NOLOCK due to data movement. April 15, 2013
- SQL Server monitoring March 28, 2013
- Removing database mirroring March 21, 2013
- SQLServer LooksAlive and IsAlive Check March 18, 2013
- Builtin\Administrators cannot login in to SQL Server March 17, 2013
- SQL Server assert in Location: purecall.cpp:51 March 7, 2013
- Trace waits in SQLServer (SQLTRACE_BUFFER_FLUSH,TRACEWRITE,SQLTRACE_WAIT_ENTRIES,SQLTRACE_LOCK) March 4, 2013
- How to view the Space used by each table in database March 1, 2013
- FILESTREAM feature is disabled February 26, 2013
- Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. February 18, 2013
- XP_readerrorlog fails with Failed to open loopback connection. February 18, 2013
- TCP Provider: The semaphore timeout period has expired February 15, 2013
- Unable to connect to Microsoft Distributed Transaction Coordinator (MS DTC) to check the completion status of transaction. February 14, 2013
- SQL Server integration services fails to start. February 13, 2013
- Query to find SQL Server CPU utilization 2012. February 13, 2013
- How to view xml plan as graphical execution plan February 13, 2013
- Top queries by total I/O and average I/O in SQL Server February 12, 2013
twitter password reset said
Hi there, You have done a fantastic job. I’ll definitely digg it and personally suggest to my friends. I am sure they’ll be benefited from this site.
Search Engine Optimization said
Hello! I simply want to give a huge thumbs up for the nice data you’ve
right here on this post. I will likely be coming again to your weblog for more soon.
Junior said
However, traders that show trading setups in real time and practice what they preach and prove their skill
and knowledge openly on the internet are the ones that are likely to
be genuine. And the beauty here is the fear and greed
demons stay below in the netherworld, since there is so
little risk or no risk. If you have been taking into consideration trading forex
trading and are fascinated in a arms off and automatic method you need to
undoubtedly verify into employing this style of software
for currency buying and selling.
imac repair kuala lumpur imac repair kuala lumpur imac retina repair malaysia said
Excellent post. I was checking continuously this blog
and I am impressed! Extremely helpful information specifically the last part :
) I care for such information much. I was seeking this
particular info for a long time. Thank you and best of
luck.
Beulah said
Very soon this web page will be famous amid all blog users, due to
it’s nice articles
iphone Repair bangsar said
Hi there, I think your web site could possibly be having internet browser compatibility issues.
Whenever I take a look at your website in Safari, it looks fine however when opening in I.
E., it has some overlapping issues. I simply wanted to provide you with a quick heads
up! Besides that, wonderful website!
Carmine said
What’s up Dear, are you actually visiting this website daily, if so then you will definitely take nice experience.
dressesshewrote.co.uk said
Your style is unique compared to other people
I’ve read stuff from. Many thanks for posting when you’ve got the opportunity, Guess I’ll just book mark this web site.
Maricruz said
Cognitive-behavioral therapy is abbreviated as CBT.
Anxiety treatment with CBT does not work with individuals who are not prepared to work
together with the therapist to reach a new way of
thinking, especially if you believe you can’t help your feelings, or that you are relying on something, or someone else to make you happy. Cognitive behavior therapy assists people in recognizing negative thoughts and maladaptive beliefs.
Philomena said
I visited several web pages except the audio quality for audio songs current at this web site is in fact
superb.
Candra said
Life coaching is the process practiced by life coaches.
s self-awareness, confidence, and the symbiotic balance
of personal and career responsibilities and objectives, they are
better able to help women in all facets of their lives.
The game-tying touchdown didn’t only leave a dagger in the heart of Broncos’
fans everywhere, but also left 31 seconds on the clock.
hair loss due to stress cure said
chinese medicine cure hair loss
world green symbolizes said
I’m really loving the theme/design of your website. Do you ever run into any internet browser compatibility problems? A few of my blog readers have complained about my site not operating correctly in Explorer but looks great in Firefox. Do you have any tips to help fix this problem?
big houses for sale said
It’s actually a great and helpful piece of info. I’m satisfied that you just shared
this useful information with us. Please stay us informed like this.
Thanks for sharing.
wiredtree hosting said
Hi, Neat post. There is an issue together with your website in web explorer, may test this?
IE nonetheless is the market leader and a big element of other folks
will leave out your excellent writing because of
this problem.
ipad screen Repair Petaling jaya said
Its such as you read my mind! You appear to grasp so much about this, such as you wrote
the guide in it or something. I believe that you can do
with some percent to drive the message home a bit,
but other than that, this is great blog. A great read.
I will certainly be back.