Prev: SQL Agent 2005
Next: Deadlock
From: isabelle on 15 May 2007 16:20
Hi,

I'm seeing some errors in the SQL server error logs:

-Downgrading backup log buffers from 1024K to 64K
-AppDomain 14 (MVXEDU.JBNET\dbryan[runtime].13) is marked for unload due to
memory pressure.
-Not enough memory was available for trace when trying to run profiler
My server is Win 2003 R2 Enterprise Edition SP1, in Task Manager I see:
Physical Memory (k) Total: 33549308 Avail:30361340 System Cache:7235528

I ran some System Monitor counters in two 15 min intervals and get the
following:

Memory: Avail Bytes 3.1050E+010 3.1041E+010
Memory: Pages/Sec 1.592 1.355
Process: Working Set 2639784438 2641416110
SQL Server: Buffer Cache Hit Ratio 99.853 99.846
SQL Server: Buffer Manager Total Pages 194472 194472
SQL Server: Memory Manager Total Server Memory (KB) 1555776 1555776
In the server properties, we do not have AWE enabled and min server memory =
0, max server memory = 2147483647, Index creation Memory = 0 and min memory
per query = 1024 (which I think is all the defaults)

I'm new to SQL and Windows so can anyone take a look at my numbers and tell
me if they look okay or if anything is giving an inidication of the memory
issues I'm having. They look okay to me, but as I said I am new to this so I
would love some extra opinions!

Thanks,
Isabelle

 | 
Pages: 1
Prev: SQL Agent 2005
Next: Deadlock