MSSQLWIKI

Karthick P.K on SQL Server

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

About these ads

28 Responses to “Script to free cache”

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. Beulah said

    Very soon this web page will be famous amid all blog users, due to
    it’s nice articles

  6. 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!

  7. Carmine said

    What’s up Dear, are you actually visiting this website daily, if so then you will definitely take nice experience.

  8. 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.

  9. 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.

  10. Philomena said

    I visited several web pages except the audio quality for audio songs current at this web site is in fact
    superb.

  11. 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.

  12. chinese medicine cure hair loss

  13. 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?

  14. 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.

  15. 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.

  16. 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.

  17. their hair said

    Hello! I just wish to offer you a big thumbs up
    for the great info you have right here on this
    post. I’ll be coming back to your blog for more soon.

  18. their hair said

    Hello! I just wish to offer you a big thumbs up for the great info you have right here on this post.
    I’ll be coming back to your blog for more soon.

  19. webpage said

    Hey There. I found your blog using msn. This is a very well written article.
    I will make sure to bookmark it and return to read more of your
    useful info. Thanks for the post. I’ll certainly return.

  20. wordpress.com said

    You can definitely see your enthusiasm in the work
    you write. The world hopes for more passionate writers
    such as you who aren’t afraid to say how they believe. All the time go after your heart.

  21. toy horses said

    This is my first time visit at here and i am genuinely impressed to read everthing at single place.

  22. Have you ever thought about including a little bit more than just your articles?

    I mean, what you say is valuable and everything. But imagine if you added some great
    graphics or video clips to give your posts more, “pop”! Your content is excellent but
    with pics and videos, this site could undeniably
    be one of the greatest in its niche. Very good blog!

  23. I don’t even know the way I ended up right here, however I
    thought this post was once great. I don’t know who
    you are but definitely you’re going to a famous blogger in the event you aren’t already.
    Cheers!

  24. Very good site you have here but I was wanting to know if you knew of any user
    discussion forums that cover the same topics discussed in this article?

    I’d really love to be a part of online community where I can get responses from other knowledgeable individuals that
    share the same interest. If you have any recommendations, please let me know.
    Cheers!

  25. […] Script to free cache […]

  26. With the right kind of data, the best spirit and the proper
    resources, you will likely be set into developing a flourishing Internet
    business. While an excellent list builder and autoresponder will amount to some money
    upfront, it’s well worth becoming your subscribers,
    readers and purchases climb higher. Individuals do understand that this
    its idols won’t clothe themselves in imitations plus obtaining the
    very best models might fee a substantial amount.

  27. Often called the ‘final frontier,’ space represents one of the last uncharted regions available
    to humans. There is lot of scope for fresh business opportunity in all regions.
    They introduced themselves and got our names so when they needed information they
    could just refer to us.

  28. Quality content is the key to invite the users to pay
    a visit the web site, that’s what this site is
    providing.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 2,088 other followers

%d bloggers like this: