office (1/18/2009)
Hello -- I'm working with much smaller databases for web-based database applications using SQL Server Express 2005. I've been very pleased with it for the last few years but, unfortunately, I am now getting occasional slow-downs whereby the database server seems to be hanging. I suspect it's the database server because I occasionally get the same behavior when running queries in Management Studio... Although I can't find the cause of the problem or a solution -- it only happens occasionally (but it's frustrating when it does!) -- I thought I would mention this here because the symptoms I'm experiencing are the same, but I'm only dealing with small databases! Also, I should mention it's only happening on my "localhost" which runs XP Pro but, fortunately, it's not happening on my live hosting server which runs W2K3 Server Web Edition.
You should probably start a new topic so that more people see your question and respond to it.
Real quick, you need to gather data to validate that it is SQL Server causing your slow-downs. You might start with this article[/url]. It's pretty introductory and kind of high level, but I think it'll help. When you do post to the new thread, include as many details as you can so that people who are not sitting at your desk can understand the problem.
Finally, if you're running a web server and SQL Server side-by-side, you will hit issues. SQL Server is a great piece of software, but it doesn't play well with others, if you know what I mean.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning