Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
d3ng
Yak Posting Veteran
83 Posts |
 Posted - 2008-11-27 : 02:23:35
|
| How to get Page life expectancy value? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-27 : 02:28:31
|
Run SQL Profiler.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
d3ng
Yak Posting Veteran
83 Posts |
Posted - 2008-11-27 : 02:47:11
|
| Honestly, I dont have any idea how to analyze Page life expectancy value using SQL Server Profiler. Can you give me some idea(s) on how to use this? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-27 : 02:53:17
|
My bad... I was distracted by other things.You need to run performance monitorGoto Control Panel -> Administrative Tools -> PerformanceAdd a counter, select "Buffer manager" and then "page life expectancy".
E 12°55'05.63"N 56°04'39.26" |
|
|
|
d3ng
Yak Posting Veteran
83 Posts |
Posted - 2008-11-27 : 03:01:59
|
| Is the "buffer manager" a performance object once you click add counters? I cant find the "buffer manager" inf perfmon? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-27 : 03:04:10
|
Buffer Manager is prefixed with the instance name of SQL Server you wish to profile.In first textbox, select the server you want to profile.Beneath scroll down do "...$instancename - Buffer Manager".
E 12°55'05.63"N 56°04'39.26" |
|
|
|
d3ng
Yak Posting Veteran
83 Posts |
Posted - 2008-11-27 : 03:14:24
|
| How about the ff: where can I find it from perfmon performance object? Thanks1)Buffer cache hit ratio2)Total server memory3)Total server available memory4)Cache hit ratio |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-27 : 03:27:10
|
1) ...$Instance:Buffer Manager2) ...$Instance:Memory Manager
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Page life expectancy