64 BIT SQL Server

Hi,
We are working with SQL 2005 64 Bit server, with 16GB Ram, now our database
size is going 57 Gb, but our server performance is very poor, I configured
Min
memory to 1024 MB and Max memory to 14 GB, now my page File usage showing
15.7 Gb, and machine is going slow, some time i saw some transaction is going
Suspended mode,
my Box task manager showing available M Bytes 270 MB,
your answers will be appreciate and help full to me
Jay
Thanks steen for reply,
but every day am doing main tables index and every week end i am doing total
tables rebuilding the index and in the week end i am updating the statistics
also.
but my server very slow. do u know why i allocated min memory to 1 GB and
max memory to 14 gb , remaing 2 GB for os but in Task manager its showing 230
mb Available.
please your reply will be great guidence to me
regards
jay
""Steen Schlüter Persson (DK)"" wrote:

> Jay wrote:
> Hi Jay,
> Performance is not only a question of Memory..:-).
> What about indexes and statistics on you database - Are they being kept
> updated? You could also look at the the performance counters to see what
> it is that is slow.
> Try to take a look at -
> http://www.sql-server-performance.com/sql_server_performance_audit2.asp
> - that should give you an idea which counters to look for.
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator
>
|||Jay -
Did you change the min/max using the GUI tool? If so, you still need to go
into a query window and do a:
reconfigure with override
It sounds like you are still running with the default max memory value
(which is something like 2TB).
|||Hello apf,
thanks for your mail.
yes i did this configuration through t-sql commans only.
dear apf i am waiting for your reply, it will be more help full to me
"apf" wrote:

> Jay -
> Did you change the min/max using the GUI tool? If so, you still need to go
> into a query window and do a:
> reconfigure with override
> It sounds like you are still running with the default max memory value
> (which is something like 2TB).
>
>
|||Jay -
If your output of:
sp_configure, 'max server memory (MB)'
returns with a RUN VALUE of 14336 (i.e. 14GB), then your SQL Server memory
is set correctly and your problem is elsewhere.
|||Dear APF,
its showing right but my server is too much slow, i am sending to you my sys
configuration details.
am waiting for your reply.
my database is hitting every seconds 30000
configuration_idnamevalueminimummaximumvalue_in_usedescriptionis_dynamicis_advanced
16391Ad Hoc Distributed Queries1011Enable or disable Ad Hoc
Distributed Queries11
1550affinity I/O mask0-214748364821474836470affinity I/O mask01
1535affinity mask0-214748364821474836470affinity mask11
1551affinity64 I/O mask0-214748364821474836470affinity64 I/O mask01
1549affinity64 mask0-214748364821474836470affinity64 mask11
16384Agent XPs1011Enable or disable Agent XPs11
102allow updates0010Allow updates to system tables10
1548awe enabled0010AWE enabled in the server01
1569blocked process threshold00864000Blocked process reporting
threshold11
544c2 audit mode0010c2 audit mode01
1562clr enabled0010CLR user code execution enabled in the server10
1538cost threshold for parallelism50327675cost threshold for
parallelism11
400cross db ownership chaining0010Allow cross db ownership chaining10
1531cursor threshold-1-12147483647-1cursor threshold11
16386Database Mail XPs0010Enable or disable Database Mail XPs11
1126default full-text language1033021474836471033default full-text
language11
124default language0099990default language10
1568default trace enabled1011Enable or disable the default trace11
114disallow results from triggers0010Disallow returning results from
triggers11
109fill factor (%)001000Default fill factor percentage01
1567ft crawl bandwidth (max)100032767100Max number of full-text crawl
buffers11
1566ft crawl bandwidth (min)00327670Number of reserved full-text crawl
buffers11
1565ft notify bandwidth (max)100032767100Max number of full-text
notifications buffers11
1564ft notify bandwidth (min)00327670Number of reserved full-text
notifications buffers11
1505index create memory (KB)070421474836470Memory for index create
sorts (kBytes)11
1570in-doubt xact resolution0020Recovery policy for DTC transactions
with unknown outcome11
1546lightweight pooling0010User mode scheduler uses lightweight
pooling01
106locks0500021474836470Number of locks for all users01
1539max degree of parallelism00640maximum degree of parallelism11
1563max full-text crawl range402564Maximum crawl ranges allowed in
full-text indexing11
1544max server memory (MB)1400016214748364714000Maximum size of server
memory (MB)11
1536max text repl size (B)655360214748364765536Maximum size of a text
field in replication.10
503max worker threads0128327670Maximum worker threads01
1537media retention003650Tape retention period in days01
1540min memory per query (KB)102451221474836471024minimum memory per
query (kBytes)11
1543min server memory (MB)1024021474836471024Minimum size of server
memory (MB)11
115nested triggers1011Allow triggers to be invoked within triggers10
505network packet size (B)4096512327674096Network packet size11
16388Ole Automation Procedures0010Enable or disable Ole Automation
Procedures11
107open objects0021474836470Number of open database objects01
1557PH timeout (s)601360060DB connection timeout for full-text
protocol handler (s)11
1556precompute rank0010Use precomputed rank for full-text query11
1517priority boost0010Priority boost01
1545query governor cost limit0021474836470Maximum estimated cost
allowed by query governor11
1541query wait (s)-1-12147483647-1maximum time to wait for query
memory (s)11
101recovery interval (min)00327670Maximum recovery interval in
minutes11
117remote access1011Allow remote access00
1576remote admin connections0010Dedicated Admin Connections are
allowed from remote clients10
1519remote login timeout (s)200214748364720remote login timeout10
542remote proc trans0010Create DTC transaction for remote procedures10
1520remote query timeout (s)0021474836470remote query timeout10
16392Replication XPs0010Enable or disable Replication XPs11
1547scan for startup procs0010scan for startup stored procedures01
116server trigger recursion1011Allow recursion for server level
triggers10
1532set working set size0010set working set size01
518show advanced options1011show advanced options10
16387SMO and DMO XPs1011Enable or disable SMO and DMO XPs11
16385SQL Mail XPs0010Enable or disable SQL Mail XPs11
1555transform noise words0010Transform noise words for full-text
query11
1127two digit year cutoff2049175399992049two digit year cutoff11
103user connections00327670Number of user connections allowed01
1534user options00327670user options10
16389Web Assistant Procedures0010Enable or disable Web Assistant
Procedures11
16390xp_cmdshell1011Enable or disable command shell11
"apf" wrote:

> Jay -
> If your output of:
> sp_configure, 'max server memory (MB)'
> returns with a RUN VALUE of 14336 (i.e. 14GB), then your SQL Server memory
> is set correctly and your problem is elsewhere.
>