Post reply

I was checking how many conditions can slow my stored procedures, pls tel me critarias in following category

  • March 14, 2014 at 12:06 am

    #148520

    Hi,

    I am using following to free up buffer and catch (Only for testing , to find speed of SP in diffrent situation)

    is there any thing else i can add to following list.

    DBCC FREEPROCCACHE

    DBCC DROPCLEANBUFFERS

    some body suggested me, one shouod not bother about these thing but i wanted to know.

    Q) We know DBCC DROPCLEANBUFFERS automatically flushs it self , based of memory and buffer/catch hit ratio.

    Please tel me how and when this gets flushed or not used DBCC FREEPROCCACHE

    yours sincerley.

  • March 14, 2014 at 12:42 am

    #1697038

    It is OK if you use this On the test/dev environment but suggested not to use it On PROD server.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • March 18, 2014 at 10:17 am

    #1698114

    rajemessage 14195 (3/14/2014)

    Hi,

    Q) We know DBCC DROPCLEANBUFFERS automatically flushs it self , based of memory and buffer/catch hit ratio.

    Please tel me how and when this gets flushed or not used DBCC FREEPROCCACHE

    Check this for better understanding ...

    http://technet.microsoft.com/en-us/library/aa337560(v=sql.105).aspx

    --

    SQLBuddy

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply