dbTalk Databases Forums  

High virtual size of sqlsvr.exe

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss High virtual size of sqlsvr.exe in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Zaur Bahramov
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.