We have two SQL servers that are used to build warehouses. Both servers will hang with no notice. We are able to ping the server, but cannot remote connect in anyway. We have to force a shutdown to restore the server to a working state.
The sql programming for the build is rather poor and a lot of times SQL's CPU is through the roof, but we can still remote in.
I am trying to get the responsible department to work with the vendor to streamline the programming. In the mean time is there something I can do with the memory, etc(?) to keep SQL from overtaking the OS? At least that is what our network engineer
says is happening.
PS: Our SQL and hardware are completely up to date with service packs.
View Complete Post