Jump to content

sivanagamahesh

Members
  • Content count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About sivanagamahesh

  • Rank
    Newbie
  • Birthday 08/09/1991

Contact Methods

  • Website URL
    http://kosmiktechnologies.com/

Profile Information

  • Gender
    Male
  • Location
    Hyderabad
  1. I have one distribution center server which got information/match up from heritage framework day in and day out, I saw some of my reports/SQL occupations execution is dubious and more often than not I got notification from DBA group that my inquiry is hindering to other adjust process. From DBA group I came to know summon i.e. Executive SP_WHO2 by which I can recognize spid of question which causes hindering by investigating segment BlkBy. If it's not too much trouble recommend me how I can abstain from blocking and different approaches to check obstructing in SQL Server. Thank u kosmiktechnologies.com
×