Sample Header Ad - 728x90

Activity Monitor (SSMS) timeout error on Sql server instance

1 vote
1 answer
4989 views
**Environment:** Window server 2012R2: RAM = 4GB Sql Server 2008R2: Min server memory = 0MB Max server memory = 2147483647MB **Background of problem:** I am managing database of asp.net application and recently application started to crash (when user tried to sign-in to the application; user see timeout exception on the browser). In order to rectify the issue I set **timeout =1000** in connection string of webconfig file and that resolved the issue. When application was crashing I tried to turn on the activity monitor on Sql server instance but I coudn't start activity monitor and got following error: enter image description here **My finding so far:** enter image description here I started my quest and troubleshooted and found that there is memory pressure but I need expert advice if there is any link of activity monitor not starting with memory pressure? I know error is from database as Sql server was busy at the time of crash. How I can further troubleshoot the problem?
Asked by shaadi (47 rep)
Aug 23, 2017, 02:33 AM
Last activity: Aug 24, 2017, 12:27 AM