.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

minimum permissions to run sp_who2, queries against dm views and activity monitor

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
Hi.  I'm trying to explain some suspended tasks that could be tied to blocks on a remote server source.  I want just enough permissions to run sp_who2, activity ssms monitor and the data mgt view query you see below.  What permission should I request minimally to do this?  We're on STD 2008. SELECT *,   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 FROM sys.dm_exec_requests AS r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS st     

View Complete Post

More Related Resource Links

Execution Plan in Activity Monitor (Recent Expensive queries)

If we see the execution plan of a query in Activity Monitor > Recent Expensive Queries is it Estimated Execution Plan or Actual Execution Plan ?

SSMS 2008 Activity Monitor Activity Monitor is unable to execute queries against server (SQL Server

I get the following error when running SQL Server SSMS 2008 (32-bit) on my (Windows 7 64-bit) workstation against our SQL Server 2005 (32-bit) development server running Windows Server 2003 (32-bit): TITLE: Microsoft SQL Server Management Studio ------------------------------ The Activity Monitor is unable to execute queries against server <my server\instance name>. Activity Monitor for this instance will be placed into a paused state. Use the context menu in the overview pane to resume the Activity Monitor. ------------------------------ ADDITIONAL INFORMATION: Unable to find SQL Server process ID 2256 on server VTX-DEV-01 (Microsoft.SqlServer.Management.ResourceMonitoring)   I can expand the panes and all display data except Overview and Data File I/O. This is true for all instances on that server. The SSMS 2005 Activity Monitor (also on my workstation) works fine when connected to that server. I checked for the registry setting to disable the performance counters on both my machine and the server, and it was not there. I started the Performance Counter DLL Host on my machine, but that made no difference. I can see all Processor counters on the server from my local Performance Monitor. I ran "lodctr /R" on both systems, but that didn't help. The only SQL counters I see on the server (from my workstation) are SQLServer:SSIS Pipeline and SQLServer:SSIS

sql 2008: the activity monitor is unable to execute queries against server

Installed sql server 2008 entrprise edition on VM server windows 2008 (64bit). When launch Activity Monitor, get:

The Acityvity Monitor is unable to execute queries against server <server name>.
Activity Monitor for this instance will be placed into a paused state.
Use the context menu in the overview pane to resume the Activity Monitor.

Additional information:
   Unable to find SQL Server process ID xxxx on server <server name>

Tried to "use he context menu in the overview pane to resume the Activity Monitor" and got the same error again.

Installed sql 2008 in my XP machine, I can use Activity Monitor (AM) for local instance but cannot launch it for the instance on the server (same error).

Used windows authentication with sysadmin role for connection from my machine. On the server used domain\administrator that the account created the instance.

Please help.

A Simple XML-driven Tool: Monitor Your Web Site's Activity with COM and Active Scripting


This article describes a simple Web site monitoring tool built with XML, JScript, Windows Script Host, and COM objects. Although it is not intended to replace complete Web site monitoring software products, it has many useful features that help to keep Web servers up and running. An XML configuration file specifies which Web sites to monitor and the actions to be taken if the site isn't functioning properly. In addition, the tool can be scheduled to run at any specified interval using the Windows Task Scheduler. Functions that probe the sites, log events, and send e-mail notifications are written in JScript.

Panos Kougiouris

MSDN Magazine July 2000

SQL Server 2008 - Job Activity Monitor Failing

I recently began migrating to Windows 2008. One of the first servers is a server which we install our tools on. This is a new server which currently is only running the SQL Server management tools. On this server I installed the SQL Server 2008 R2 management tools, prior to this install there were no other SQL Server tools installed on this server. The majority of the functionality works and I can connect and manage multiple databases servers from SQL Server version 2000 through 2008. But when I try to bring up the Job Activity monitor I get an error ==> Can not show requested dialog. From Windows XP Windows Server 2003 SP2 this functionality works. I get this error if I connect to a SQL Server 2005 or 2008 database instance. I have tried re-installing the client tools but I still get this error..... any ideas?

Customized list views and permissions to specific group users

Hi, I have created a custom list with 20 field/columns in wss3.0. I had four user groups(group1, group2,....3.....4) in my site collection with various levels of permissions. I have created four custom views (Group 1 view, Group2 view,...etc)in my list. Each view contains only certain fields out of 20. For example group 1 view contains field 1, 5, 7,10 and 13 of every item in my list.  My requirement is that when a user login, who is a member of group1. he should be able to view only Group1 view fields. He should not able to view other field/columns. I tried creating another field/column called as restricted users and wrote group names in that. In the View edit page I selected " show item when the column 'restricted users' is equl to [Me]. But I did not get it. Kindly help it out any one either programmatically or UI based. Thanks   

List View Permissions and Views for Web Parts

My fellow developers and I are going in circles a bit with our new Sharepoint 2010.  This question probably has several different answers.   I have a list of grades and comments that our Team Leaders want to create and save on Sharepoint.  When saved, the user who was graded should be able to see their own grades.  Its a pretty simple requirement and I'm 90% of the way there.   I created a list with the required fields, and two separate views.  The first view filters the list by the user's name so they see on their grades.  The second view shows all grades in a grouped order by the person who assigned the grade.  To make this second view more readable, I added some formatting with Sharepoint Designer 2010.  It looks nice.   Here's where the speed bump occurs.  I create a web parts page for each view.  The page showing only the user grades works as expected.  The other page, however, shows the list in a view that I didn't create.  No matter what view I select from the "Edit Web Part" menu, it always shows this strange view.  If I select the list, it says its current view is "Default".  The second view I created is set as default, but its not the view I see.  If I change the current view from list menu to the second view specifically, it shows up correctly. &n

Minimum Permissions Needed To See Cdc tables In System Tables Folder

What are the minimum permissions needed for a user to see the cdc tables in the System Tables folder in SQL Management Studio?DJ Baby Anne's Biggest Fan................

SSMS 2008 & Activity Monitor's Processor Time graph is disabled

Hi,I just upgraded one of my SQL 2005 clusters to SQL 2008 with CU9.  Now, when I connect to it with SSMS, either from my workstation or directly on a cluster node, the % Processor Time graph in the Activity Monitor screen is disabled.  The other three graphs are fine.  If I connect to a different SQL 2008 server, the % Processor Graph is fine.  I don't see any errors in any app event log.  Has anyone else seen this behavior?Thanks!

Setting permissions to Items/Views in a list

I have a list containing 2 FY's data. I need to make one of the FY year's data as read-only. Can i create a view filtering only this data and make only this view as read-only or do i need to edit permissions of individual items of the filtered FY and set it as read-only. Is there any other way of doing this?

sql Server 2008: duplicated rows in Activity monitor

There are identical notes (Session id, Login etc.) in a Processes tab of Activity Monitor. Usially it is two, sometimes three same rows. Does anyone have a similar situation? Is this a bug or it is just s/th wrong in my comp? (SQL Server 2008 R2 CUP3)

How to estimate "Minimum query plan threshold for considering queries for parallel execution(cost es



We have 4 QUAD core processors and we have set max degree of parellelism to 4(as suggested by Microsoft). As of now we are using the default value for "Minimum query plan threshold for considering queries for parallel execution(cost estimate)".

Please suggest how to estimate the best value for for "Minimum query plan threshold for considering queries for parallel execution(cost estimate)"?

Thanks in advance.



SQL 2008 Management studio and Activity monitor


I have an sql 2008 server with Windows 2008 R2 firewall on and the port 1433 and 1434 are open. When I run Activity Monitor from SQL studio remote I can't see all database activity but if I go local on the server I can, why is that ? Another port that should be open or ?


\\Jonas B

Minimum permissions to allow users to respond to survey

Morning all,

I have created a survey which has been authorised to go live.  I am looking to give an AD group with a few hundred users access to the survey so they can respond.
However, I am finding it difficult to create a custom permission level (this will be used repeatedly throught our SharePoint environment) that allows the user to access the survey and successfully submit their repsonse.  I can get the users to the survey and when they click respond.... it shows the first question.  When they click on Next, it shows access denied!

I can only get this working if I use contribute or full control but I don't want the user's going in and changing the q's/deleting the survey etc etc.

Does anyone know the minimum permissions to allow what I require?


Activity Monitor not available in SQL Server 2008?


I've just recently installed SQL Server 2008 Standard.

However, I don't see Activity Monitor listed under the Management folder. I installed all the necessary software, so there can't be any missing software components. My network administrator gave me all the necessary permissions for the server. We're using Windows Authentication for logins. When I used SQL Server 2005 on another server machine, Activity Monitor was available.

Did Microsoft drop Activity Monitor from SQL 2008?

If not, how do I get Activity Monitor back?

Rupertsland, Canada

Needs an expert advice on bleow sp_who2 queries



I need to automate one of the below 3 scripts in a .net application to check blocking. Can anybody please tell me which script will give high performance. I will appreciate if someone mention reason Why I should use selected SQL Script. The 3 queries are as follows:

Script 1:

if exists (select spid from master..sysprocesses where blocked <> 0)

Using Transact SQL Queries in Data Source Views


Afternoon all,

Can someone explain how I would use a view defined in SQL in my data source view creation and what the advantages of doing so would be. I've been assigned to a project where I need to build a DSV, but the database has a view that appears to create what I need too.

I've read in some MS literature that a view can be used in lieu of referencing the actual tables.

Can anyone explain how this would work?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend