Tuesday, July 16, 2013

TSQL statement of running queries

In a SQL production environment it can happen that you see heavy transactions. With next query you can retrieve the TSQL statement of a process you see in master..sysprocesses.

SELECT Text,hostname, program_name, nt_username,*
FROM Master..sysprocesses
CROSS APPLY sys.dm_exec_sql_text (sql_handle)
WHERE Spid > 50


You can extend the WHERE clause with SPID = XX or something else you wnat to filter on.

7 comments:

unknown said...

Interesting blog on the TSQL running queries". I also a need the information on these topic. Do you these reason I'm not cover the assignment taking online service from the assignment assistance UK this is the one the best writer in the UK.

Unholy Blades said...

I have completely read your blog. Recently have i complete change the our home roof from the Roofing Corpus Christi this is the best service in the USA.

Unknown said...

Laptop warriors, rejoice! Battery life is your precious fuel. Aim for at least 8 hours for uninterrupted coding sessions. Consider lightweight best gaming tablet under 200 with efficient processors for extended unplugged adventures.

james said...

If you're traveling with a lot of luggage, you may want to consider booking a car service or shuttle instead of a Edinburgh Airport Taxi. This will give you more space for your luggage and can be more convenient, especially if you're traveling with a group of people.

Bryan Chapbell said...

Graphic design in Pakistan has gained significant prominence with the increasing demand for visually appealing and communicative design across various industries graphic designers in pakistan

archana shah said...

Hello! I recently stumbled upon an informative post that I think you might enjoy reading. Also, have you had a chance to check out the latest stainless steel 410 plates, 347 stainless steel sheet suppliers, and 347h stainless steel sheet? They are definitely worth looking into!

Keira Stevenson said...

TSQL running queries are very technical as it includes data analytics, statistical values. So many of the students are feeling depressed and seeking help in TSQL. I used reviews for the dissertation help their TSQL assistance are very helpful for my project. they provide TSQL notes that help me to prepare my next project.