Link to home
Create AccountLog in
Avatar of SteveSext
SteveSext

asked on

Windows Server 2008 32 bit and SQL server 2005 optimisation

Hi
I have a Windows Server 2008 32 bit server running SQL server. SQL server regularly crashes and needs to be restarted. i.e. Sql replication jobs fail, timeouts are experinced by users. Once restarted, it all works fine again.
Does anyone know of any good SQL optimisation tricks that need to be added to optimise performance. In winodws 2003, I used /3gb /pae but I bellieve this has changed in windows server 2008.
Has anyone got any tips on this?
thanks
ASKER CERTIFIED SOLUTION
Avatar of lnkevin
lnkevin
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of SteveSext
SteveSext

ASKER

There is 4GB physical RAM installed. SQL becomes unresponsive and client applications start getting timeout errors. No errors in teh SQL error log, the only error in the windows event log:
the connection has been lost with Microsoft Distributed Transaction Coordinator (MSDTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Coordinator (MSDTC) will begin once teh connection is re-established.
Error 8562.
Are there other event logs leading up to this one that shed light why MSDTC becomes unresponsive?
Is this a single SQL server or is it part of a cluster?
the only other event is "string message: INFORMATIONAL : CSO::Maintain_SSTATE_UP session Failed Error = 0x80004005 RpcStatus = 164", Event id 4156
it is not a cluster
I have not seen this type of error. you might want to follow the suggestion from mastoo to see whether you have an issue.
Is this a web application that uses the DB or is it a client application running on each workstation?
I may have missed it, but you are not running anything else (God forbid IIS) on the same server as MS SQL Server are you?
no not running iis on this machine
So it is running standalone on this box?
yes, it is a sql server, windows server 2008 32 bit and sql server standard 2005
If MS SQL Server is all that is installed on that box, then I honestly have no idea what is going on.  We have servers with as little as 4GB with hundreds of databases that do not have that problem.
USERVA seems to work