Viewing 8 posts - 1 through 8 (of 8 total)
I'll waiting 😎
The Database ist about 60 GB.
I don't user this....
June 23, 2010 at 3:42 am
Adam,
he're the results of ypur statement.
physical_memory_in_bytes
------------------------
17167736832
virtual_memory_in_bytes
-----------------------
8796092891136
Number of 8KB buffers in buffer pool
------------------------------------
12160
Number of 8KB buffers needed by the buffer pool
-----------------------------------------------
1728000
Status of Dynamic Memory
-----------------------------------------------
Extra memory needed from OS for Buffer...
June 23, 2010 at 3:12 am
Try PAL reports from http://pal.codeplex.com.
It's an analysis tool based on Windows Performance Counter.
If your os other then english you'll need the add on PLT to translate your...
June 23, 2010 at 1:58 am
So, today I changed the min server memory and restartet the Server.
sp_configure 'min server memory', 6500
Reconfigure
go
sp_configure 'max server memory', 13500
Reconfigure
go
But it seams not ok:
SQL Buffermanager -> Free Pages ...
June 23, 2010 at 1:41 am
Sorry, wrong answer......Total Server Memory and Task Manager....both nearly the same
June 22, 2010 at 12:45 pm
I set up the standar performance counter with a interval from 60 sec and I analysed it with the PAL Reports from codeplex [/url].
PAL searched throug the logs which where...
June 22, 2010 at 12:43 pm
I've the similar Problem on by new SQL-Sever, having a lot of freee memory. I still not found a resolution.
June 22, 2010 at 12:25 pm
It was figured like that before, after I checked the PAL Reports I raised it up.
We got "Less than 640 Free Pages" on the SQL Buffermanager (about 130) and...
June 22, 2010 at 12:03 pm
Viewing 8 posts - 1 through 8 (of 8 total)