How long does a SP stay in the cache?
As a SQL Database Developer or Administrator you must be eager to know how long does a stored procedure execution plan stay in the cache? On what basis and parameters MS SQL Server decide age of an execution plan to reside in cache?
Well the answer is, it is based on the cost factor and number [...]
Categories
Archives
Recent Posts
Tags
administrator
alarm
audit
bufer
cache
change log
checkpoint
compression
data collector
DBA
dbcc checkdb update sql perfmon
DDL Triggers
DDL_DATABASE_LEVEL_EVENTS
disk space shrink dbcc shrinkfile database sql server shrink
email
event
event_instance
high availability
lazywriter
log
logshipping
management
memory
mirroring
msdb
notification
policy
resource governor
restart
restore
shipping
sp
sql
sql audit
sql server
stored procedure
vldb
warehouse
workload
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Jun | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | |||
SQLKnowledge.com
- Audit databases – using ddl triggers
- Hot topics to work on in SQL 2008
- Common logshipping issues!
- Join us on LinkedIn
- List of Undocumented DBCC command..
- How long does a SP stay in the cache?
- Get Notification as soon as SQL Services are restarted
- Script to find used and free space in Database files
- Website renovated