Monitor SQL Queries
Feb 29, 2008I'm trying to record all the queries running on a specific database to a file.
Does anybody know of free or commercial utility that can do that?
ADVERTISEMENT
Setup And Upgrade :: Activity Monitor Shuts Down If Connect To Instance Its Monitoring With Performance Monitor
Aug 19, 2015If I'm on a remote machine, meaning a computer not in the WSFC cluster, and I open SSMS 2014, point it to a SQL Instance, and open activity monitor:
1. I get all the panes and charts except % Processor Time.
2. Then, if I authenticate to the cluster's domain by mapping a drive with valid domain credentials, I'm free to put performance counters in the Perfmon - - - but SQL Activity Monitor shuts down with“The Activity Monitor is unable to execute queries against server SQL-V01INSTANCE1..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: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))(Mscorlib)”
3. Of course, the Activity monitor can't be resumed via the context menu. Removing counters and closing the perfmon do not work. I dropped the mapped drive and rebooted the machine. That brought back 95% of the information in the Activity monitor.
4. Further experimentation showed that any mapping of drive shares present on the SQL Server to the computer running SSMS cut off functionality of the 'overview' pane in the remote machine's SQL Activity monitor -- the monitor that had been trying to watch the server offering the shares.
Red X Show On Replication Monitor (publications Is Disconnected From Replication Monitor)
Jan 30, 2007I have setup transactional replication everything on one box. later(two or three weeks later), Replication monitor is show red X Under my publishers (publications is disconnected). this is SQL2005.
Everyone known how to fix this problem?
Thanks,
Frank
How Can I Monitor My SQL?
Oct 23, 2007Hi, Today, I heard about Sql Profiler, and I seems to be a tool to monitor, analyze, and fine tune sql server. Is there a tool like this for SQL Server Express 2005? thanks,John
View 1 Replies View RelatedHow Do I Monitor My SQL JOB?
Apr 29, 2004Hullo. I have a SQL SCHEDULER Job that keeps hanging.
1) How do I monitor this? I would like to have another Sql Job monitor the first one hourly, and send me an email if it is hanging. Isn't there a system table that tells me a job status?
1a) Once I find the job, how can I "Stop it" automatically?
2) Is there a way to have the Job stop itself it it runs for more than 20 minutes?
Thanks.
~Le
How To Monitor SQL Jobs Using C#
Apr 3, 2008Hi ..
i have a task to monitor the sql jobs..
i wish to do with this with C# or asp.net application.
please help me to finish this..
Connection Monitor?
Jan 20, 2004Hi all,
Can anyone please tell me whether there are any ways we can check whether a connection that was opened to a SQL Server database is closed. Is there a tool we can use?.
Thx
Hakl
Performance Monitor
Jun 4, 2001Would the Performance Monitor be the best tool
to use if you wanted to find out how many transactions
are being process a day?
System Monitor
Aug 1, 2003How do I access performance monitor (system monitor).I am using Windows 2000 professional, SQL server 2000. Do I need to set up analysis service or something? I am not seeing system monitor on my box? am I missing something?
View 5 Replies View RelatedPerformance Monitor
Dec 18, 2001Hello all,
I want to know whether any performance monitoring tools/procedure available in market for SQL Server other than Performance monitor, Profiler, Query Ananlzer of SQL Server.
thank you in advance.
regards,
Nana
Performance Monitor
May 11, 1999Hi guys!
Please tell me where is mistake?
I have win.nt workst. 4.0 and SQL Server 6.5 Client Configuration Utility installed.
I open Performace monitor and try to add to chart sql server which already have been registered in SQL Enterprise Manager.
And I have error message: Computer name not found.
Why??????
Thank you.Sev
NT Performance Monitor
Oct 14, 1998Until this week, I had full functionality of SQL Monitor`s capabilities to monitor SQL Server. Now, when I select our Production Server and attempt to `Add to Chart` I am unable to view/select any SQL Server... entries in the `Object` dropdown list box. When I click the down arrow with the Development server selected I DO see all of the SQL Server selections. This inability to `see` the SQL Server functions in the Performance Monitor for the Production server exists regardless of whether I attempt to view them from a Win NT 4.0 Workstation or at the Server`s console. Again, I had full functionality from both locations last week. The logins have not changed. What has changed?
ANY help would be GREATLY appreciated. I need to monitor this system and I`m running blind at the monent.
TIA
Mike Gaudet
Visages, Inc.
Monitor Server
Jul 9, 2002Hello,
I do all my monitoring locally for disk space, locks, blocking, I've 10 production servers, We need to centralised the monitoring server so from one server all the monitors can be done. Does anyone has any ideas how memory, cpus consumption, disk space, all alerts, locks, blocking, log space and job completition monitoring can be handled.
Any idea or guidance is appreciated
Thanks
Roma
Performance Monitor
Jan 4, 2001Help ????????
I have a winnt and sql server 6.5 when i open up sql performace monitor it doesn't show any thing it comes blank when i go to reintialize the sqlserver object is not there i need to know how can i fix it
its urgent
girimanjesh
How To Monitor SQL Server
Feb 22, 2007Hi,
How do most of you monitor your SQL servers (i.e. performance, cpu utilization, job failures...)? Can you recommend any tools that are not too costly?
Thanks.
Mary
Monitor DiskSpace
Jan 20, 2004I have discovered that there is an extended procedure called xp_fixeddrives, which can check how much space you have on your SQL Server's drives, it works fine. Can some one tell me what can I use to monitor the above (space used on drive) on servers that do not have SQL at all. Remember I want to call that from my SQL NOT from VB
View 1 Replies View RelatedPerf Monitor
Feb 24, 2004Is there anyway that you can automate performance monitor from the cmd line. I.e feed it some parameters like server and counters and receive a log file at the end.
Cheers
Activity Monitor
Apr 10, 2008Is there a way to allow a user to run activity monitor without making that user system admin
View 9 Replies View RelatedActivity Monitor
Apr 23, 2008Hi experts,
I just want to know how can i kill all the processes of a database
if the database have more than 100 connections.This is for the purpose of restoring a database.
RKNAIR
How To Monitor My SQL Server?
May 16, 2008Hi all,
I'm very new with SQL Server. My company just purchased a dedicated server and we installed SQL Server 2005 Express Edition. The operating system is Windows Server 2003.
We have only 8 databases in that machine and there is this 1 particular database that keeps getting error. I know that the database is in error if I go to the Management Studio Express and I expand the database, that particular database has no [+] expand symbol and if I try to view the properties it will say "out of memory error" or something like that.
How can I find out what is causing this error? That database has is 18MB and is not used frequently. The error usually appears once every month.
How to debug this issue?
thanks in advance
Activity Monitor
Apr 10, 2007Is there a way to give access to non-admins on ACTIVITY MONITOR?
------------------------
I think, therefore I am - Rene Descartes
SQL Monitor Tool
May 20, 2007Hi,
Our company is looking for SQL monitoring tool. Please give any recommendations.
Thx
How To Monitor Through MOM For A Database
Feb 7, 2008Hi experts,
I never used "monitoring through MOM for a sql databse". so can any one explain, how to monitor through MOM.
-Thanks N Regards,
Kanthi.
Sql Performance Monitor
Mar 13, 2008Does anyone know of a good and preferably free sql performance monitor? I feel my site is running a little slowly after some changes i made and i would like to check it out. Thanks.
View 1 Replies View RelatedReplication Monitor
Jul 23, 2005I'm experiencing some very odd behavior in Enterprise Manager.I have a process that performs the following:1.) Restores a published database from Server A onto Server B. Thedatabasesare identical and they are both published.2.) I run a script that then deletes the subscriptions to thepublication onServer B. I do this via SP_DROPSUBSCRIPTION.3.) I run a script that then deletes the publication. I do this viaSP_DROPPUBLICATION.4.) Deletes the distribution database.5.) Deletes the old jobs.6.) Creates the publication from pregenerated scripts.7.) Adds the subscriber.8.) Adds the subscription.9.) Generates the snapshot and applies it.What's happening is that I'm seeing the job name that's assigned to thedistribution job increment by 1 each time this process is run. Also,I'mseeing ten instances of the publication showing up in the tree view.Everything appears to be rtunning just fine, transactions beingreplicated,etc. I'm just wondering is there something I'm missing in my steps.Plus,after two or three months of this, might not look so good having 90publications showing up in the tree view.Thanks!
View 1 Replies View RelatedJob Activity Monitor
Sep 10, 2007Hi,
I have a problem with Job Activity Monitor.
I have a SSIS which copies data from a table to a flat file. The connection string of this file is variable and the file is reused if not exists and is created if exists.
When I run the SSIS manually from my microsoft visual studio it works properly. However, when I run this SSIS from the Job Activity Monitor, I get the following error:
Message
Executed as user: REDCAMadminsql2k5. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:41:10 AM Error: 2007-09-10 08:48:04.99 Code: 0xC020200E Source: Crear Historico Historico [1] Description: Cannot open the datafile "\srvnfileHISTORICOSCAJEROSOFI3210C01OFI3210C01_2007-7X.txt". End Error Error: 2007-09-10 08:48:04.99 Code: 0xC004701A Source: Crear Historico DTS.Pipeline Description: component "Historico" (1) failed the pre-execute phase and returned error code 0xC020200E. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:41:10 AM Finished: 8:48:53 AM Elapsed: 462.234 seconds. The package execution failed. The step failed.
Any idea?
Thanks.
How Do You Monitor SQL Server?
Jul 17, 2007We've got a growing database server that is quickly getting more active. I wanted to find out how folks monitor their SQL Server 2005 instances? What tools have worked for you? What guidelines have you followed?
In particular, I want to be able to establish which database is driving the most activity, and diagnose which calls or statements are causing the most resource usage. On a bigger picture I want to understand how others are approaching monitoring in general with regards to SQL Server 2005.
Thanks!
Colin
Can I Monitor What Goes In Tempdb
May 22, 2007Hi,
I've noticed that our application occassionally causes the tempdb log file to grow quite large. I'm not a dba, nor do we have one onsite, so I'm trying to read up on things that cause the tempdb file to grow. Having done that, I don't see anything obvious that our application is doing (checked things like temp tables, cursors, group by, order by, etc).
So I was wondering if there is any monitoring that I could do on the tempdb itself to see when and how it is being accessed? And what kinds of things are getting stored in tempdb? If my application does create objects in the tempdb table and then deallocates the object, shouldn't that keep the size of the tempdb in check? Or would that not have any effect on the tempdb.log file?
Also, it is the tempdb.log file that grows quite large - is there a way programmatically to clear the log file? I know there is a shrinkdb option from the Enterprise Mgr. Should my application periodically be doing something to shrinkdb (assuming it does use tempdb appropriately) in order to keep the size from growing too much?
Thanks in advance,
Beth
Replication Monitor Bug?
May 30, 2007There seems to be a problem with the replication monitor correctly telling you the progress of applying database schema.
Here is my setup:
Running SQL 2005 SP2. Publishing with merge replication (push) via a VPN. Approx 100 tables with lots of filtering, using data partitions filtered on host_name()
When you create and initialize a new subscription if you go to the Replication Monitor and open the Sync History window for that new subscription. You will see that it is setting up the schema in the subscriber but it does not update the status at the bottom of the window it just continually says:
Applying Database Schema - 0% complete (approzimately 00:00:00 remaining)
If it helps you can see an image of this below you will notice that it is already 15 minutes into a process that will probibly take 2 hours but it still says 0% complete.
If you require any further info or have any suggestions as to why this is not a bug (just me being dumb) please let me know.
You can see an image of this problem here: https://applications.ccusa.com/2/images/snychistory.jpg
Thanks In Advance.
Martin
Monitor SQL Agent Job In ASP.Net
Nov 22, 2006Hi all,
I have a web page which calls a SQL Agent job to initiate an SSIS package. Is there any way i can monitor the job and detect once it has completed successfully? At present all i can seem to get is the return status of whether the job has started or not.
Any help would be most appreciated,
Many thanks in advance.
Grant
Monitor I/o, Cpu Etc. Without Traces
Aug 21, 2006Any suggestions on how I can monitor the following without using traces? I am a dba/developer working as a developer on a contract, and I'm supposed to be tuning. However, I can't run traces. I've got my own procs that monitor locking, etc. But I would like to get at least i/o and cpu throughout the day. It would also be nice to get the query executed. Basically, the type of stuff you'd normally use traces for.
I know about @@cpu, @@io etc., but these are basically useless (no?) since they only record since the server was started. There is a stored proc but it only monitors these things since the last time it was run.
Does anyone know how I could utilize the above? I tried to write a script but I couldn't get it to work. :(
I realize that in general this is a ridiculous request, but I thought I would ask anyway.
Parameterized Queries Running Slower Than Non-parameterized Queries
Jul 20, 2005HelloWhen I use a PreparedStatement (in jdbc) with the following query:SELECT store_groups_idFROM store_groupsWHERE store_groups_id IS NOT NULLAND type = ?ORDER BY group_nameIt takes a significantly longer time to run (the time it takes forexecuteQuery() to return ) than if I useSELECT store_groups_idFROM store_groupsWHERE store_groups_id IS NOT NULLAND type = 'M'ORDER BY group_nameAfter tracing the problem down, it appears that this is not preciselya java issue, but rather has to do with the underlying cost of runningparameterized queries.When I open up MS Enterprise Manager and type the same query in - italso takes far longer for the parameterized query to run when I usethe version of the query with bind (?) parameters.This only happens when the table in question is large - I am seeingthis behaviour for a table with > 1,000,000 records. It doesn't makesense to me why a parameterized query would run SLOWER than acompletely ad-hoc query when it is supposed to be more efficient.Furthermore, if one were to say that the reason for this behaviour isthat the query is first getting compliled and then the parameters aregetting sent over - thus resulting in a longer percieved executiontime - I would respond that if this were the case then A) it shouldn'tbe any different if it were run against a large or small table B) thisperformance hit should only be experienced the first time that thequery is run C) the performance hit should only be 2x the time for thenon-parameterized query takes to run - the difference in response timeis more like 4-10 times the time it takes for the non parameterizedversion to run!!!Is this a sql-server specific problem or something that would pertainto other databases as well? I there something about the coorect use ofbind parameters that I overall don't understand?If I can provide some hints in Java then this would be great..otherwise, do I need to turn/off certain settings on the databaseitself?If nothing else works, I will have to either find or write a wrapperaround the Statement object that acts like a prepared statement but inreality sends regular Statement objects to the JDBC driver. I wouldthen put some inteligence in the database layer for deciding whetherto use this special -hack- object or a regular prepared statementdepending on the expected overhead. (Obviously this logic would onlybe written in once place.. etc.. IoC.. ) HOWEVER, I would desperatelywant to avoid doing this.Please help :)
View 1 Replies View RelatedMonitor Replication With Vb Code
Jun 3, 2004I have to write a little vb6 app to monitor sql 2000 replication. The app must run on the same desktop as the subscriber.
I've tried the samples that comes with sql (replsampl) but that is to do the replication, I need to just monitor replication that was set up in sql 2000.
With monitor I mean to show a red light when replication is busy, so that the user doesn't disconnect from the network while replication is in progress.
Any ideas?