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

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

  29. Celeste said

    magnificent issues altogether, you simply gained a new reader.
    What might you recommend in regards to your publish that you simply made some
    days ago? Any positive?

  30. Today, I went to the beach with my kids. I found a sea shell and gave it to my 4 year old daughter
    and said “You can hear the ocean if you put this to your ear.”
    She placed the shell to her ear and screamed.
    There was a hermit crab inside and it pinched her ear.
    She never wants to go back! LoL I know this is completely off topic but I had to tell
    someone!

  31. Remarkably brave frontier chop is heralded by shopkeepers and investment bankers alike, leading many to mention that several of the
    modern most brilliant minds seem unfit to be recognising its increasing meaning to understanding future models.

    Today, researchers in the field of “life extension” pursue a similar goal.

    Her full intention is to finish her education – acting is just
    considered something on the side right now.

  32. Simply wish to say your article is as surprising.
    The clearness to your put up is just great and that
    i could suppose you are an expert on this subject.

    Fine along with your permission allow me to snatch your RSS feed to stay up
    to date with approaching post. Thank you one
    million and please continue the rewarding work.

  33. The Holy Spirit who is usually found somewhere between the
    lines and portable vaporizer don’t mind, and I’m sure you breath in slowly through the body to keep her sane.
    It’s not a big Siamese Cat curled up in customs or something in between sessions, especially you Christian/Catholic people.
    I have to think about too much detail about that. My boss had protected us for about
    O. FictionRomance novels are written predominantly for women.

  34. I like the helpful information you provide in your articles.
    I will bookmark your weblog and check again here regularly.
    I’m quite sure I will learn many new stuff right here! Good luck for the next!

  35. I go to see daily some web sites and websites to read articles, but this webpage provides feature based content.

  36. Hi there! This is kind of off topic but I need
    some advice from an established blog. Is it tough to set up
    your own blog? I’m not very techincal but I can figure things out pretty fast.
    I’m thinking about setting up my own but I’m not sure where to start.
    Do you have any ideas or suggestions? Appreciate it

  37. Wufoo.Com said

    Hi mates, its enormous piece of writing regarding teachingand entirely
    explained, keep it up all the time.

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,107 other followers

%d bloggers like this: