dcsimg
Results 1 to 2 of 2

Thread: How to check blocking queries in SQL Server Ask?

  1. #1
    Join Date
    Dec 2017
    Location
    hyderabad
    Posts
    2

    How to check blocking queries in SQL Server Ask?

    Hi,

    I have one stockroom server which got information/match up from heritage framework every minute of every day, I saw some of my reports/sql occupations execution is questionable and more often than not I got notification from DBA group that my inquiry is obstructing to other synchronize process.

    From DBA group I came to know summon i.e. Executive SP_WHO2 by which I can distinguish spid of question which cause hindering by investigating section BlkBy.

    If it's not too much trouble propose me how I can abstain from blocking and different approaches to check obstructing in SQL Server

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,905
    You can run sp_who instead, sp_who2 creates a temp table that can cause blocking.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •