ULC Flushes 
Author Message
 ULC Flushes

I'm trying to increase percentage of User Log Cache flushes 'by the end
of transaction'. I came over ULC size problem and change of database
effect, but sp_sysmon shows 'by System Log Record' for ULC flushes
around 96% all the time.

can u list the system activities that cause ULC flush ? how can I
increase 'by end of transaction' percentage for ULC flushes? . (ULC
size is really sufficient, 'by Full ULC' on sys_sysmon output is always
0)

SQL Server/11.0.3.3/P/Sun_svr4/OS 5.4/SWR 8837 ESD 6/OPT/Wed Jan 19
14:04:22 PST 2000

Thanks.

Sent via Deja.com http://www.***.com/
Before you buy.



Tue, 22 Apr 2003 23:08:27 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Fast commit flushes and write behind flushes

2. TBS Write Flush Error on Acer NT Server

3. How to flush buffer cash?

4. Flushing the SP cache in SQL Server 7

5. How to flush procedure cache?

6. how to flush the procedure cache?

7. Flushing the buffers

8. Write error during log flush. Shutting down server

9. Flush Log files - Urgent

10. mem is not getting flush out.

11. Prints not being 'flushed'??

12. Page scan/ Cahce Flush


 
Powered by phpBB® Forum Software