[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

My MS SQL 2005 is working slowly, problem with suspended - need help

Hello Guys

I have a MS SQL 2005 installed in my server.
It was working perfectly until last Monday, now it is very slow and as I could notice the
MS SQL 2005 is having a lot of suspended.

The version of my MS SQL 2005 is service pack 2

What could it cause this? What should I do?

thanks
0
hidrau
Asked:
hidrau
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
run sp_who2 and check to see any processes having 'blkdby' column non empty
 
if possible try restarting the sql server services ..
 
0
 
hidrauAuthor Commented:
Hello aneeshattingal:

It is all right in the column
0
 
hidrauAuthor Commented:
thanksd
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now