September 18, 2003 at 8:18 am
Hi,
We have a production web site using SQL server database. When the user can not access the web, the web request queue is building up but no activity on database server. It was fine to do TSQL from QA, but when I tried to open Enterprise Manager it hung. Is there a way to tell what the database is doing at that moment? How can I tell the SQL database is running ok or not?
Thank you?
wc
September 18, 2003 at 8:34 am
Are your Web server and SQL Server in different machines? Can you ping to SQL Server from Web Server when you have the problem? Any error message in SQL Server errorlogs? Is there any blocking in SQL Server? What about SQL Server machine's performance, ie CPUs usage and memory usage from Task manager?
September 18, 2003 at 8:34 am
You can run profiler to check what is executing in the server or in a specific database.
You should also run sp_who2 to know what proceses are running and with dbcc inputbuffer (spid) you can check the queryes running for each user.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply