Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hirani_prashant
Yak Posting Veteran
93 Posts |
 Posted - 2008-10-20 : 05:10:13
|
| Hello All,Currently we are having below configurations...*****************************************************************name minimum maximum config_value run_valueAd Hoc Distributed Queries 0 1 0 0affinity I/O mask -2147483648 2147483647 0 0affinity mask -2147483648 2147483647 0 0Agent XPs 0 1 1 1allow updates 0 1 0 0awe enabled 0 1 0 0blocked process threshold 0 86400 0 0c2 audit mode 0 1 0 0clr enabled 0 1 1 1cost threshold for parallelism 0 32767 5 5cross db ownership chaining 0 1 0 0cursor threshold -1 2147483647 -1 -1Database Mail XPs 0 1 1 1default full-text language 0 2147483647 1033 1033default language 0 9999 0 0default trace enabled 0 1 1 1disallow results from triggers 0 1 0 0fill factor (%) 0 100 0 0ft crawl bandwidth (max) 0 32767 100 100ft crawl bandwidth (min) 0 32767 0 0ft notify bandwidth (max) 0 32767 100 100ft notify bandwidth (min) 0 32767 0 0index create memory (KB) 704 2147483647 0 0in-doubt xact resolution 0 2 0 0lightweight pooling 0 1 0 0locks 5000 2147483647 0 0max degree of parallelism 0 64 0 0max full-text crawl range 0 256 4 4max server memory (MB) 16 2147483647 2048 2048max text repl size (B) 0 2147483647 65536 65536max worker threads 128 32767 0 0media retention 0 365 0 0min memory per query (KB) 512 2147483647 1024 1024min server memory (MB) 0 2147483647 0 0nested triggers 0 1 1 1network packet size (B) 512 32767 4096 4096Ole Automation Procedures 0 1 1 1open objects 0 2147483647 0 0PH timeout (s) 1 3600 60 60precompute rank 0 1 0 0priority boost 0 1 0 0query governor cost limit 0 2147483647 0 0query wait (s) -1 2147483647 -1 -1recovery interval (min) 0 32767 0 0remote access 0 1 1 1remote admin connections 0 1 0 0remote login timeout (s) 0 2147483647 20 20remote proc trans 0 1 0 0remote query timeout (s) 0 2147483647 600 600Replication XPs 0 1 0 0scan for startup procs 0 1 0 0server trigger recursion 0 1 1 1set working set size 0 1 0 0show advanced options 0 1 1 1SMO and DMO XPs 0 1 1 1SQL Mail XPs 0 1 1 1transform noise words 0 1 0 0two digit year cutoff 1753 9999 2049 2049user connections 0 32767 0 0user options 0 32767 0 0Web Assistant Procedures 0 1 0 0xp_cmdshell 0 1 1 1*****************************************************************Can any one tell me which parameters needed changes or say what should be the ideal configurations??ThanksPrashant Hirani |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
What should be the ideal conficurations...