Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I was checking how many conditions can slow my stored procedures, pls tel me critarias in following category Expand / Collapse
Author
Message
Posted Friday, March 14, 2014 12:06 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 19, 2015 10:49 AM
Points: 81, Visits: 213
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.
Post #1551018
Posted Friday, March 14, 2014 12:42 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 22, 2015 8:03 AM
Points: 2,720, Visits: 2,130
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."
Post #1551032
Posted Tuesday, March 18, 2014 10:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, January 23, 2015 2:58 PM
Points: 1,194, Visits: 2,243
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

Post #1552303
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse