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
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
Microsoft SQL Server 2005Windows Server 2008
Last Comment
SteveSext
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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?
Is this a single SQL server or is it part of a cluster?
ASKER
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
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?
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?
ASKER
no not running iis on this machine
So it is running standalone on this box?
ASKER
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.
ASKER
USERVA seems to work
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.