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

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

SQL Server 2008 - Job Activity Monitor Failing

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
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?

View Complete Post

More Related Resource Links

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 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)

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.

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

The exact meaning of "Executions/Min" in SQL Server 2008 Activity Monitor


We are having issue understanding the "Executions/Min" in the Recent Expensive Queries" section of Activity Monitor in SQL Server 2008.

Activity Monitor shows we have 189,411 execution of "insert into t_LiveChat_SessionIncludingNavigatingAndChat33497(visitorId, startTime, Ip, referrerUrl) values(@visitorId, @startTime, @Ip, @referrerUrl)" per minutes. However, if we use SQL Profile to track all ""insert into t_LiveChat_SessionIncludingNavigatingAndChat33497(visitorId, startTime, Ip, referrerUrl) values(@visitorId, @startTime, @Ip, @referrerUrl)" in 2 minutes.

Also, I used the following SQL:


SELECT total_worker_time ,

 execution_count ,

 total_worker_time / execution_count AS [Avg CPU Time] ,

  total_logical_reads, total_logical_writes, total_physical_reads,total_elapsed_time, *,

 CASE WHEN deqs.statement_start_offset = 0

  AND deqs.statement_end_offset = -1

 THEN '-- see objectText column--'

 ELSE '-- query --' + CHAR(13) + CHAR(10)

  + SUBSTRING(execText.text, deqs.statement_start_offset / 2,

  ( ( CASE WHEN deqs.statement_end_offset = -1

   THEN DATALENGTH(execText.text)

   ELSE deqs.st

SQL Server Network Interfaces Error 26 - while failing over SQL Server 2008 R2

Before I explain the issue I am facing, I would like to say that I did read the post at  http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx but in my case the problem is transient (lasts for approximately two minutes after a failover) so items 1-3 in the list of troubleshooting steps do not seem to make sense. As to 4 and 5, the named instances use non-default ports (2433 and 3433 respectively), so I do not know how to tailor the PortQry command for that. I tried  portqry.exe -n ServerA,2433-p UDP -e 1434 and  portqry.exe -n ServerA,2433 -p UDP -e 2434 and it failed both times with a "Failed to resolve name to IP address" while the server was up and serving database requests The same thing happened when I tried it with the failover server as well. ***The issue I am facing*** I am using Enterprise Library 4.1 to connect to a SQL Server 2008 R2 database with a mirror. My connection string itself is as below (with dummy values for all fields): "Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=DBName;User ID=uid;Password=pwd;Connect Timeout=5" Sample .NET code is as below (with modifications to instantiate all variables locally to provide context): SqlDatabase db = new SqlDatabase(ConnectionString); SqlConnection cn = (SqlConnection)db

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!

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

SQL 2008 SP1 - Log shipping solution with Logshipping monitor on SQL Server Express Edition SP1 (bad


Hello All !

I'm installing a log shipping solution with SQL Server 2008 Standard SP1 (on x64 US). I use a monitor logshipping with SQL Server Express Edition x64 SP1 US. When I try to connect it, I have this message when i tried to use w.x.y.z\SQLEXPRESS  as a monitor server:

'w.x.y.z\SQLEXPRESS' is not a valid monitor server instance.  A monitor server instance must be SQL Server Standard Edition, SQL Server Workgroup Edition, or SQL Server Enterprise Edition.'

In SQL 2005, it is possible to do that with SQL Express. And with 2008 R2, is it possible too or it is the same problem ?

Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2

Sql Server Agent Job Activity Monitor Columns


Hi All,

        We have a requirement to produce the replica of the SQl Server Agent Job Activity Monitor in a list view.We are aware that there are Sql Server Agent stored procedures to get it done.But the problem is that we are not able to obtain columns like Runnable,Category from those stored procedures.

Is a stored procedure readily available for getting it done? Please help us in this regard.





How can I monitor all SQL statements that are executed on my SQL Server 2008 R2 Express?



Is there any possibility to monitor (e.g. using log file) all SQL statements that are executed on SQL Server Express version?

I have SQL Server 2008 R2 Express.

I know that there is SQL Profiler but this tool is not available on Express version. How can I monitor all SQL statements on Express version?




Sql Server 2008 import and export wizard is failing


Sql Server 2008 import and export wizard is failing with the message: \


The ‘DbProviderFactories’ section can only appear once per config file. (System.Configuration)

This wizard will close because it encountered the following error: (Microsoft SQL Server)


This happens when I hit the “Next” button on the initial import/export wizard startup screen.


The detailed error message is below.  Any ideas on the location of the configuration file that the change needs to be made to?   

Auditing User Activity in SQL Server 2008 Enterprise

Is there a way to audit the activity of a certain login in SQL?  For example, I want to know everything that user "Test" does after he logs in.  Is that possible?

Sql Server 2008 Tutorials

This Link Provides total Sql Server 2008 Tutorials

Seven reasons to care about SQL Server 2008 R2

Microsoft begins to fully realize its vision of SQL Server as an information platform and not "just" a database. Hence the main theme for this release -- at least according to Microsoft -- is self-service BI. The PowerPivot plug-ins for Excel 2010 and SharePoint 2010 are easily going to make the biggest splash of all the new features, not least because they're the most complete. But then, SQL Server 2008 R2 isn't strictly necessary for PowerPivot for Excel, which works with plenty of other data sources.

Error upgrading SQL Server 2008


i was normally using VS2005 and SQL server 2005...

i upgraded to SQL Server 2008... and then...

i could not build my project anymore... because of this error:

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
Exception Details: System.IO.FileNotFoundException: The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Source Error: 

sql server 2008 adventureworks database


dear Friends

For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008. 

And the query is 

-- MERGE Statement
USE AdventureWorks2008
MERGE INTO	Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;	

Please help me to overcome this issue and let me know where can I download that database too.

Thanking you

happy Coding

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