November 4, 2005 at 3:47 pm
Hello
I have a server with 4 GB of ram, Raid 5 system disk with cash controller scsi active.
On this server i just have only install windows 2000 server and MSQL 2000 server.
My network lan is optical fibers connect to a switch.
Connect to this server , i have more an less 30 pc working on it.
MSQL service in the task manager take 1,7/1,8 GB of Ram.
In this moment i have a poor response of sql server and of cause in my server.
I have changed the properties of MSQL to boost and use automatically available memory.
Could any one give me a suggestion to turn my server more faster because in this moment when for example someone run a transaction on my accountancy program to see a report of balance and an other pc try to save an invoice all the system become work very slower and also the server.
Many thanks
Luis Santos
November 4, 2005 at 4:05 pm
See
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=235185
SQL = Scarcely Qualifies as a Language
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply