RE:[sap-basis] ST04 BW zero data cache
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Superbasis (SAP Basis Administrator) on Jan 29 at 8:36 PM |  Mark as helpful |
check db collector jobs
---------------Original Message---------------
From: spike28
Sent: Tuesday, October 27, 2009 2:00 AM
Subject: ST04 BW zero data cache
> Hi SAP Guru's, <br/>Kindly help check this issue. I ran St04 in our BW system and noticed that data cache has a zero value: <br/>Phys. Memory (MB) 16.127,0 <br/>Current Memory (MB) 0,0 <br/>SQL Memory Setting FIXED <br/>Windows Memory Option - <br/><br/>Data Cache (MB) = 0,0 Hit ratio = 0,000<br/>Proc Cache (MB) = 0,0 Hit ratio = 0,000<br/>Lock Cache (MB) = 0,0<br/>Free Pages (MB) = 0,0<br/>Buffer Lookups per SQL Batch 0,000 <br/>Page Reads / Readahead Pages 0,000 <br/> Lazy Writes/sec 0,000 <br/> Log Flushes/sec 0,000 <br/> <br/> Full Tab/Idx Scans/sec 0,000 <br/> Index Range Scans/sec 0,000 <br/> Index Searches/sec 0,000 <br/> Probe Scans/sec 0,000 <br/>Current Memory (MB) 0,0 <br/> Buffer Pool(MB) 0,0 <br/> Data Cache (MB) 0,0 <br/> Proc Cache (MB) 0,0 <br/> Free Pages (MB) 0,0 <br/> Connection Memory(MB) 0,0 <br/> Optimizer Memory (MB) 0,0 <br/> Lock Memory (MB) 0,0 <br/> <br/>Target Server Memory (MB) 0,0 <br/> <br/>I already checked that Database collector and SAP collector is running. Our BW system have as database Microsoft SQL Server 2005 - 9.00.4035.00 (X64) SP3 Enterprise Edition<br/>thanks, <br/>Spikey
__.____._ ---------------Original Message---------------
From: spike28
Sent: Tuesday, October 27, 2009 2:00 AM
Subject: ST04 BW zero data cache
> Hi SAP Guru's, <br/>Kindly help check this issue. I ran St04 in our BW system and noticed that data cache has a zero value: <br/>Phys. Memory (MB) 16.127,0 <br/>Current Memory (MB) 0,0 <br/>SQL Memory Setting FIXED <br/>Windows Memory Option - <br/><br/>Data Cache (MB) = 0,0 Hit ratio = 0,000<br/>Proc Cache (MB) = 0,0 Hit ratio = 0,000<br/>Lock Cache (MB) = 0,0<br/>Free Pages (MB) = 0,0<br/>Buffer Lookups per SQL Batch 0,000 <br/>Page Reads / Readahead Pages 0,000 <br/> Lazy Writes/sec 0,000 <br/> Log Flushes/sec 0,000 <br/> <br/> Full Tab/Idx Scans/sec 0,000 <br/> Index Range Scans/sec 0,000 <br/> Index Searches/sec 0,000 <br/> Probe Scans/sec 0,000 <br/>Current Memory (MB) 0,0 <br/> Buffer Pool(MB) 0,0 <br/> Data Cache (MB) 0,0 <br/> Proc Cache (MB) 0,0 <br/> Free Pages (MB) 0,0 <br/> Connection Memory(MB) 0,0 <br/> Optimizer Memory (MB) 0,0 <br/> Lock Memory (MB) 0,0 <br/> <br/>Target Server Memory (MB) 0,0 <br/> <br/>I already checked that Database collector and SAP collector is running. Our BW system have as database Microsoft SQL Server 2005 - 9.00.4035.00 (X64) SP3 Enterprise Edition<br/>thanks, <br/>Spikey
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
In the Spotlight
Share Knowledge About SAP Scripting. Join the New Discussion Group
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
