| Author |
SQL Configuration and Optimization
|
|
|
| Hi!
I wanna know, please, some advises and tips to configurate my SQL server.
Here are some details about the hardware and traffic:
Pentium 3 500 MHz and
512 MB of RAM
The average every month of hits is about 9.000.000 with 1.700.000 page views
and 150.000 visitor sessions and 70.000 unique visitors
I have some doubts about this setting in the SQL properties:
-Memory
[Dinamically configure SQL Server memory] OR should i use a fixed memory
size???
-Process control
[Maxium worker threads = 255] is it OK? what should i use as an average?
-Connections
[Maximum concurrent user connections = unlimited] i have very doubt about
this, with the number of my web site traffic souldnt i limit this??? whay
would you use???
Thank you so much, i hope you can help me to improve it.
| |
| GlennThomas5 2005-06-13, 11:23 am |
| are you using this as your web server and database server? if you are
i would definately suggest using a fixed memory size b/c sql is going
to allocate it all to itself and your web apps are goign to lag.
nice work on the traffic. btw =)
| |
|
| No, the SQL and the WEB server are separated.
| |
| Peter Yao 2005-06-14, 9:23 am |
| What do you feel it's slow?
Are you using old IDE drives?
What's the database size?
New hardware with 1+ GB memory would definitely speed up the performance.
> Pentium 3 500 MHz and 512 MB of RAM
| |
| GlennThomas5 2005-06-14, 8:23 pm |
| yea i this a desktop you converted to a server ? sounds like it. whats
the drive speed? i'd go w/ at least 2 GIGs of RAMM if you can. it's
cheap enough. :)
|
|
|
|