ms sql slow

ms sql slow
 If you found that your sql server is slow and almost not responding to the request made by web application and you also observed that
CPU and Memory utilization at normal level. Then.

Here is how you can investigate

Open SQL query analyzer and fire below query to know how many number of connections opened to which database?

SQL query

select db_name(dbid) as DataBaseName , count(dbid) as No_Of_Connections , loginame as LoginName  from sys.sysprocesses 
                                                                                                                                        where dbid > 0
                                                                                                                                     group by dbid,loginame


By frequently running this query. You observed that the number of connections opened is high then there exist bug in your application
which didn't closed the opened connections
. Stop the web application who uses that database and start over, system would run first
and later it suffers slow response then stops responding. In this situation you need to fix your application and not to blame SQL server.

Satalaj

Tags:

ms sql slowgodaddy hosting MS SQL server configurationThis page contains secure and none secure information Do you want to display the none secure itemsDo you want to display nonsecure itemsms sql versionMS Sql Random selectAn unhandled exception of type systemstackoverflowexception occurred in mscorlibdllMS SQL server 2005 attach databse without ldf fileMS SQL server service packms sql newid functionMS SQL server Transaction commit rollbackMS SQL server mirroring remove end points master key

Author

My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in ASP.net year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.
 

I'm Satalaj.