Printable View
Does anyone know of a way I can load test an installation of sqlexpress 2005 ?
I have a number of installs out there and am having issues with express. It seems to be getting stuck in the middle of a transaction and jamming up causing complete failure of my application.
Its an unusual problem.
The db only throws this problem up after a while. Its as if its building up crap
Any techniques or tools would be much appreciated.
Thanks All
Try to Install
Visual Studio Service Pack 1 (SP1)
Before that install vs Sp1
Install VS Preparation Tool
It will Remove un wanted Patch HOTFix files.
Then Install SQLEXPRESS 2005/2008
I'm a bit confused.
As far as I know I have all that installed.
Ok
When you installation time , Which Step its going to hang?
It's not getting stuck during install...
It's getting stuck in a transaction - while users are accessing the database - right?
Can you get onto the network while this "hanging" is occuring?
Open a query window - EXEC SP_WHO or EXEC SP_WHO2 - this will tell you who is deadlocking the database.