Skip to main content

SQL Blocking query 

SELECT   s.session_id,
                 r.status,
                 r.blocking_session_id                                 'Blk by',
                 r.wait_type,
                 wait_resource,
                 r.wait_time / (1000.0)                             'Wait Sec',
                 r.cpu_time,
                 r.logical_reads,
                 r.reads,
                 r.writes,
                 r.total_elapsed_time / (1000.0)                    'Elaps Sec',
                 Substring(st.TEXT,(r.statement_start_offset / 2) + 1,
                           ((CASE r.statement_end_offset
                              WHEN -1
                               THEN Datalength(st.TEXT)
                               ELSE r.statement_end_offset
                             END - r.statement_start_offset) / 2) + 1) AS statement_text,
                 Coalesce(Quotename(Db_name(st.dbid)) + N'.' + Quotename(Object_schema_name(st.objectid,st.dbid)) + N'.' + Quotename(Object_name(st.objectid,st.dbid)),  
                          '') AS command_text,
                 r.command,
                 s.login_name,
                 s.host_name,
                 s.program_name,
                 s.last_request_end_time,
                 s.login_time,
                 r.open_transaction_count
        FROM     sys.dm_exec_sessions AS s
                 JOIN sys.dm_exec_requests AS r
                   ON r.session_id = s.session_id
                CROSS APPLY sys.Dm_exec_sql_text(r.sql_handle) AS st
        WHERE    r.session_id != @@SPID
        ORDER BY r.status,
                 r.blocking_session_id,
                 s.session_id;


We find any output in “BLK By” then using below query :

Sp_who2 SPID
Then
KILL {session ID | UOW} [WITH STATUSONLY]
 
Example:  KILL 53;
          GO







































Comments











Post a Comment




















Popular posts from this blog



















Scraping HTML Content using Python




























 To Scrape Data using python we are using BeautifulSoup python Package    !pip install beautifulsoup4    As a first step we have to import the packages and html page that we need to scrape.  In here I have used some static HTML content which was customized to scrape the data.    #imports  import requests  from bs4 import BeautifulSoup     #html  HTML Sample    Doing Data Science with Python    Doing Data Science with Python  Author: Eranda Kodagoda  This will help to perform various data science activitied using python   Modules    Title  Duration in minutes    Getting Started  20    Setting Up Environment  40    Extracting Data  30    Exploring and Processing Data  45    Building Productive Model  45        To View the HTML using beautifulsoup we can use below code-lines and execute on python executor    from IPython.core.display import display, HTML  display(HTML(html_string))    To Print the HTML using beautifulsoup we can use below code-lines and execute on python executor    ps=Be...




















Post a Comment









Read more




























Basics of Data Science with Python




























 About Data Science with Python    From this module I will post some interesting posts about Data science and how to gather information and process them using Python and for that I will be using below softwares      Python 3.6   Anaconda   Jupyter Notebook   PyCharm by JetBrains     In the posts I will include fundamentals of Python  programming techniques such as lambdas, reading and manipulating csv files, and the numpy library.     And In the posts I will be doing a simple Data Challange which is available on Kaggle and I will provide the URL's to the github repo which I will be posting the whole module once it finished.     In Future I will be post some articles related to Applied Data Science with Python: Applied Plotting, Charting & Data Representation in Python, Applied Machine Learning in Python, Applied Text Mining in Python, Applied Social Network Analysis in Python   




















1 comment









Read more




























Selenium WebDriver Cheat Sheet




























 Below are some important code samples for those who are willing to learn Selenium automation.   Driver Initialization     WebDriver driver ;   driver = new ChromeDriver() ;  driver = new FirefoxDriver() ;  driver = new SafariDriver() ;  driver = new InternetExplorerDriver() ;  driver = new EdgeDriver() ;     // Driver Profiling  //Firefox  //Load Firefox  System. setProperty ( "webdriver.firefox.bin" , "path/to/driver" ) ;  FirefoxProfile profile = new FirefoxProfile() ;  //load with add-on  File file = new File( "path/to/add-on" ) ;  profile.addExtension(file) ;  //profile settings (setting up desired capabilities)  DesiredCapabilities capabilities= new DesiredCapabilities() ;  capabilities.setCapability(FirefoxDriver. PROFILE , profile) ;  WebDriver driver = new RemoteWebDriver(capabilities) ;     //Chrome Options  System. setProperty ( "webdriver.chrome.driver" , "/path/to/chrome/driver" ) ;  ChromeOptions options = new ChromeOption...




















Post a Comment









Read more