High virtual size of sqlsvr.exe -
11-12-2009
, 03:16 AM
Hi!
I have installed a SQL Server 2008 Std on Windows Server 2008 64 bit on
ESX Server 3.5.
The configuration of the Windows 2008 Server:
RAM: 8Gb
Page File: max/min - 12288 Mb
C:\ - installed SQL Server
D:\ - Database
L:\ - TL
When I start the server the physical memory shows less than 2 gb, System
Commit(Gb) 1/19. After some time of working Physical memory rises to
7.95 Gb and Commit (Gb) shows 7 or 8 /19. Even if I don't run anything
inside SQL server, the memory remains on this values.
Write now the following values are present:
Image name: sqlservr.exe
Working Set (memory): 3.187.108 K
Commit Size: 3.260.784 K
Page faults: 1.103.341
IO Read Bytes: 156.559.181.168
IO Write Bytes: 82.282.653.852
Sysinternals proccess explorer also shows:
Virtual Size: 8.464.168 K
Is this normal? Or there's something wrong with the SQL server or
Windows 2008 Server configuration?
I've configured the SQL Server as follows (sp_configure):
name run_value
access check cache bucket count 0
access check cache quota 0
Ad Hoc Distributed Queries 0
affinity I/O mask 0
affinity mask 0
affinity64 I/O mask 0
affinity64 mask 0
Agent XPs 1
allow updates 0
awe enabled 0
blocked process threshold (s) 0
c2 audit mode 0
clr enabled 0
cost threshold for parallelism 5
cross db ownership chaining 0
cursor threshold -1
Database Mail XPs 1
default full-text language 1033
default language 0
default trace enabled 1
disallow results from triggers 0
filestream access level 0
fill factor (%) 0
ft crawl bandwidth (max) 100
ft crawl bandwidth (min) 0
ft notify bandwidth (max) 100
ft notify bandwidth (min) 0
index create memory (KB) 0
in-doubt xact resolution 0
lightweight pooling 0
locks 0
max degree of parallelism 0
max full-text crawl range 4
max server memory (MB) 6400
max text repl size (B) 65536
max worker threads 0
media retention 0
min memory per query (KB) 1024
min server memory (MB) 0
nested triggers 1
network packet size (B) 4096
Ole Automation Procedures 0
open objects 0
optimize for ad hoc workloads 0
PH timeout (s) 60
precompute rank 0
priority boost 1
query governor cost limit 0
query wait (s) -1
recovery interval (min) 0
remote access 1
remote admin connections 0
remote login timeout (s) 20
remote proc trans 0
remote query timeout (s) 600
Replication XPs 0
scan for startup procs 0
server trigger recursion 1
set working set size 0
show advanced options 1
SMO and DMO XPs 1
SQL Mail XPs 0
transform noise words 0
two digit year cutoff 2049
user connections 0
user options 0
xp_cmdshell 0 |