THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Adam Machanic

Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.

Installing Who is Active (A Month of Activity Monitoring, Part 4 of 30)

THIS CONTENT HAS MOVED HERE.

Published Monday, April 4, 2011 11:00 AM by Adam Machanic

Comments

 

maxx said:

DBCC SQLPERF(LOGSPACE) and DBCC INPUTBUFFER() both require VIEW SERVER STATE permissions.

April 4, 2011 11:36 AM
 

Darcy said:

DBCC SQLPERF(LOGSPACE)

DBCC INPUTBUFFER()

April 4, 2011 3:05 PM
 

martinz said:

Hi Adam,

Is there any advantage \ disadvantage of marking the procedure in master with sp_MS_marksystemobject?

cheers

Martin.

April 5, 2011 5:23 AM
 

Adam Machanic said:

Maxx and Darcy, good job. But it's not just DBCC SQLPERF(LOGSPACE) -- it's all features of DBCC SQLPERF.

Martin: No benefit at all. Marking a stored procedure as a system object is useful when the procedure uses the database-local views and you want to be able to call it from a database and get results from that database. Who is Active is designed to be instance global so if it needs to access data in a given database it switches its context to that database first.

April 5, 2011 10:52 AM
 

Michael Codanti said:

I just wanted to comment that Adam does take bug reports and feature requests seriously. (I wish some of the companies that we pay annual support contracts were a quarter as responsive in terms of actually fixing bugs.)

April 5, 2011 11:42 PM
 

Adam Machanic said:

This post is part 5 of a 30-part series about the Who is Active stored procedure. A new post will run

April 7, 2011 8:47 PM
 

Adam Machanic said:

This post is part 29 of a 30-part series about the Who is Active stored procedure. A new post will run

April 30, 2011 11:44 AM
 

Adam Machanic said:

This post is part 30 of a 30-part series about the Who is Active stored procedure. A new post will run

April 30, 2011 11:45 AM
 

Tim said:

Hmm, just wondering if this

SELECT *

FROM sys.databases

WHERE

   compatibility_level < 100

should be this

SELECT *

FROM sys.databases

WHERE

   compatibility_level < 90

?

September 12, 2011 2:45 PM
 

Alexander said:

First of all let me thank u about your help, it really helps me. I have some question, hope you can help me, I followed this steps

1- I installed in other database no master

2- Followed this steps at http://www.littlekendra.com/2011/02/01/whoisactive/

3- there is a field called sql_text that almost always show me <?query begin tran> not always but almost.

An also i got some messages :

Warning: Null value is eliminated by an aggregate or other SET operation.

Warning: Null value is eliminated by an aggregate or other SET operation.

Warning: Null value is eliminated by an aggregate or other SET operation.

2013-06-10 12:28:50: Logged info. Waiting...

thanks so much!

June 10, 2013 1:43 PM
 

Adam Machanic said:

@Tim: Hm, I think you're correct. Too bad I only noticed your comment almost two years later. Oh well.

@Alexander: Sounds like some app on your end is beginning transactions and then just letting 'em sit there. Might want to sort that out.

Don't worry about the warnings. They're warnings, not errors. I keep meaning to sort 'em out, since they do bother some people, but it's never been a high priority of mine.

--Adam

June 10, 2013 2:39 PM
 

Manuel Bulhao said:

@Tim,Adam: I am too always getting a lot of <?query begin tran> but I can say that they are all related to the implemented (transactional) replications/jobs. And as they are configured to run continuously, it does certainly explain this behavior.

@Adam: incredible stuff, thanks a lot.

January 27, 2014 8:43 AM
New Comments to this post are disabled

About Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

This Blog

Syndication

Privacy Statement