SQL server 2000 tweaking
Posted on 2006-04-13
We are running a custom application to enter in data on the SQL server.
That said, is it possible to have the SQL server configured wrong? Most DBA's, (not me) can tweak the server to it can achieve the highest efficiency in terms of data integrity.
Am I wasting my time, or can this be done?
Someone before me set it up, but I have reason to believe that they just installed the server and did nothing else.
The reason for the question, is sometimes this custom application may kick people out for no reason while doing a task.
I'm trying to rule out the SQL server, as it may be configured wrong. But I don't know... I'm turning to you Guru's for help.
The server is Dell, Dual 3.06Ghz Xeon's ( HT is turned off.) with 4gig of RAM running windows 2000. SQL server does not have SP4 applied. Not too sure if that will fix our problem, as I fear it may create more..
I'm assigning 500 points to this. If you can help me fix ALL of our problems, you deserve it!!!