Viewing Commands Being Executed On Sql Server In Real Time

Sep 19, 2006

I saw a presentation last week where the speaker created some sorta sql server "watch window" (in Sql Server Management Studio I think) where he could watch all the commands being executed on his sql server database in real-time. For example he could navigate to web pages (that hit the database) and as he pressed buttons you could see the sql commands execute in this "watch window."  If other users hit the database at the same time you could see those sql queries execute as well.  I didn't think at the time to ask how he did it - does anyone know how to set this up?  I have a problem with my sql server right now and it would be useful to see which sql queries (etc) are being executed when. 
Thanks in advance,
J. Shane Kunkle
jkunkle@vt.edu

View 2 Replies


ADVERTISEMENT

Log All Commands Executed In QA

Jul 23, 2005

Hi All,Is there way that commands executed in the query analyzer get loggedautomatically?TIAJoriz

View 3 Replies View Related

How SQL Commands Get Executed?

Apr 17, 2007

When we send any SQL command to database engine , how exactly it gets executed?

View 7 Replies View Related

SQL Server 2014 :: Gathering Stored Procedure Execution Time In Real Time?

Jun 11, 2015

Is there a way to keep track in real time on how long a stored procedure is running for? So what I want to do is fire off a trace in a stored procedure if that stored procedure is running for over like 5 minutes.

View 5 Replies View Related

How To View The Real SQL Statement That Was Executed In Stored Procedure?

Nov 29, 2006

Hi everyone,
 I wonder how one can see or save the real sql statement that was executed by some stored procedure (including the one that used supplied parameters)?
 
Just need that for debugging purposes...
 
thanks!

View 1 Replies View Related

SQL Server For Real Time

Apr 12, 2007

Hi,



We currently have a propriety in memory DB that is used to store the latest transactions in the system and we have a service that copies the data to a SQL Server every couple of seconds - For historical reporting purpose.



We would like to move into a more standard DB as our real time DB, since we have scalability and availability issues. We taught about using SQL Server since this is the DB we know, but I'm not sure it's built to handle real time data.



Does someone has any experience in using SQL Server for "Real Time" applications?

Does someone has any experience in storing the data files on RAM?



Does MS has a solution similar to Oracle's TimesTen, which is their real time DB?



Thanks,

Avi G..

View 3 Replies View Related

Time In Sql Server Is Not The Real Time

Apr 18, 2007

Hi,when i create a new user in a .MDF file, the hour of creation in the field "createdate" of table "membership" is exactly 2 hours less than the time of my computer. Probably something to do with different hours between Europe and UK or ...How can i set the creation hour to exact the same hour of my computer?ThanksTartuffe

View 4 Replies View Related

Scheduling A Query To Be Executed At Given Time In SQL Server 2005

Apr 4, 2007

Hi friend!

I want to schedule a query or procedure running at given time regularly eg: at 12AM daily. Please tell me how to do that in sql server 2005.

We use SQL server 2005 developer edition.

Thanks in advance.

View 1 Replies View Related

How To Convert Time From Int To Real-time

Oct 28, 2007

Hi all.

I have posted this question in another forum but no one has so far been able to provide a solution to the problem. Since I know Database Journal always has very informative and enlightening posts, I figured I'd post the question here in hopes that some guru can provide an answer.

If you're running SQL 2000 and have any jobs that have been executed, you could perform a query as such:

select last_run_time from msdb.dbo.sysjobsteps

and receive returned values that contain the last time a job was executed "stored in integer datatype" columns. See ->
sp_help sysjobsteps.

In SQL 2005 I believe the concept is the same. I think the intent of Microsoft had it mind for doing this was to store the date separate from the time values which won't work using the datetime datatype and I have read this in documentation in the past.

The challenge is to convert that data into a humanly legible 12 or 24 hour time format like 11:00 AM or 02:45:39.

Does anyone have any suggestions or clues to assist in resolving this problem??? :(

Thanks.

View 6 Replies View Related

Determine The Last Time SP Was Executed

Jul 20, 2005

Hello -I am trying to determine the last time a SP was executed. Does anyoneknow how to do this? I'm trying to cleanup some databases.Thanks!*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 3 Replies View Related

Real Time Data

Jan 25, 2007

I currently have an application which retrieves stats from a SQL database that are updated throughout the day. My application updates every 3 seconds to retrieve these stats but I found that it's quite expensive to the server's CPU when there are several clients running my application. Are there any other methods for extracting the data that won't require so much CPU. The fact that the database is being hit so much isn't good either. I have already written a webservice hoping that this would improve things but I'm not sure it has.

View 3 Replies View Related

SQL Real Time Replication

May 6, 2001

We are using SQL 7 at 2 different locations, on 2 different Domains that are connected via a T1 line.

We need to have our 2 SQL servers be identical at all times, meaning when a change is made on one server, it is immediately replicated to the other. The problem is that both servers are always being used, so there is no primary/backup server scenario.

Does anyone know if there is a third party software available, or if this is even possible to do, given the fact that the databases are always open ?

Thanks.

View 1 Replies View Related

Real Time Synchronisation

Oct 24, 2000

Hello,

Can anyone guide me. which is the best method for real time synchronisation of my production server. Is it Transactional Replication or Stand By Server?

Thanks In Advance

Sejal

View 2 Replies View Related

Real Time Replication

Apr 24, 2008

I have two database, one is for production and another for reporting database, in this Scenario we need to transfer the real time data to reporting database, which replication we need to use and what at the bottelnecks in this..can any one give some suggesstions or give some links...

Thanks in advance

View 4 Replies View Related

Synchronize DB In Real Time

Mar 22, 2007

i have 2 DB in 2 different servers.
db1 and db2

db1 gets 150k records every hour. db2 is like the backup of db1. db2 is used to retrieve records to create reports using reporting services.
what is the best way to synchronize db2 with db1?
is it to create a dts package and set up a job that runs every hour?

off topic question.
what kind of language does reporting services use to create the reports?

View 2 Replies View Related

Is There Anyone Wih Real Time Exp In Sql2005

Nov 12, 2007

hi guyz ...i m new to sql server so is there anyone who could guide me abt sql server 2005 ....i need some info abt ssis ,ssas ...i have got a proj n have sme ques regd tat so plz let me know ur no or mail id so that i could contact u ..plz its urgent

raghu

View 1 Replies View Related

Is There Anyone Wih Real Time Exp In Sql2005

Nov 12, 2007

hi guyz ...i m new to sql server so is there anyone who could guide me abt sql server 2005 ....i need some info abt ssis ,ssas ...i have got a proj n have sme ques regd tat so plz let me know ur no or mail id so that i could contact u ..plz its urgent

raghu

View 2 Replies View Related

Real-time Databinding

Sep 18, 2007

Does anybody know a good way to get a (near) live view of a sqlce database that doesn't involve ResultSets? I tried to use a resultset with the Sensitive option set, but it doesn't like the joins that I have to do in order to have the data make sense to the user.

Thanks

View 1 Replies View Related

Real Time Progress Bar

Sep 2, 2006

The ETL processing for my project will be deployed as part of a larger application which is operated by non-technical users. Therefore I want to provide real-time feedback to the user on progress, errors, etc., using windows standard GUI interface objects and style- for example a progress bar. The "designer" of course does some of this but there won't be any designer in our deployed application (and SSIS designer is neither intended to be used by, nor appropriate for, non-technical users anyway).

Now that I have the ETL logic working, it's time to tackle this UI requirement. I am thinking one way to do this is to start a script task to run in parallel with the main ETL processing, open a winform in that task that has various GUI objects whose "state" is based on package scoped variables, update the package level variables via the "on progress" event (or other events as needed) of various SSIS tasks and components, and refresh the winform's display regularly via a timer event.

Does this approach seem like it would be effective? Has anyone tried maintaining an open winform via a script task and updating it's objects via package variables in parrallel with the package is running other tasks?

Thanks,

Ken

View 2 Replies View Related

Real Time Replication With Ms Sql

Jun 28, 2007

hello,



I want to create real time replication of my databaser server.I have two database srevers,one is master which having real time data and another slave,where i want to replicate data from master .

plz help me to configure solution



Thanks,



Chetan S. Raut.

View 1 Replies View Related

How To Protect A Frequently Real Time DB

Jul 2, 2001

Hi Everybody:

We have a table which needs to be updated 2 million times per day. It hosts all real time transaction. There are 200K records in this table. Would you please to share your experience with me about how to protect/save such table in SQL 2000 from any possible damage?

We plan to use point-in-time backup (every 5 minutes). It still takes at half an hour to recover the whole database. Any new technology from Microsoft or SQL 2000 you can recommend?

Thank you very much.

Joan

View 3 Replies View Related

Table Data To A TXT In Real-time

Oct 8, 2007

Hi
I´m a SysAdmin and I´m implementing ASSP (anti-spam) to use with an email server.
But the ASSP requires a txt file with all domains hosted in the server that are in a SQL Table of the server.
My questions is: Is there anything to make a real time TXT file with all the domains ?
maybe use trigger I dont know..

View 4 Replies View Related

Real-time Feedback From Scripts

Jan 10, 2008

I'm sure just about everyone uses the PRINT command to give feedback as to what their lengthy and involved scripts are doing, as sort of a record.

I cannot figure out how to make the stuff I use in PRINT commands come out in real-time like SELECTs seem to. Does anyone have an answer to this? These are long-running scripts, and I'd rather nip a problem in the bud before the entire script completes if there's a problem I can capture.

___________________________
Geek At Large

View 2 Replies View Related

Real-time Data Minig

Sep 8, 2006

We have completed the implementation of data mining algorithms.Now we have to build an API for real time data mining.Is that possible in SQL Server?

View 3 Replies View Related

Real Time Anomaly Detection

Jan 20, 2008



Hi,
I'm would like know if the analysis service data mining enables to detect anomalies from "normal" behavior/patterns of data (1), and alert about such anomalies when detected (2). both above sql server relational DB (3).

Thanks,
Eyal

View 5 Replies View Related

Delaying Compilation Real Time

Nov 29, 2006

Hi,
I would like to find out about SSIS compilation. Can you mention anything regarding this issue or can you point me out to a website for this topic please?

Thanks

View 1 Replies View Related

Real Time Quantity Update Using Triggers

Aug 25, 2001

Hi
There are 2 databases db1 and db2 on SQL server 7 with tables 1 and 2 respectively.
Both these tables have a field called Quantity. IF quantity gets updated in table 1 then that change should be immediately reflected in table2.
I though an update on table1 would serve the purpose but this trigger doesn't seem to be working however there are no errors during the syntax check.
The code for the trigger that i have used on table 1 is as below
CREATE TRIGGER [Qty_UPDATE] ON [Table1]
FOR UPDATE
AS
IF UPDATE (Qty)
BEGIN
UPDATE db2.dbo.table2
SET db2.dbo.table2.qty = qty
END
Please help
Thanks in advance

View 1 Replies View Related

Synchronize And Compare Two Database In Real Time

Sep 7, 2006

how to synchronize and compare two database in sql server 2000 without using any others software in real time.

my purpose is to check the two database in two different server if there has any different. And synchronize these two database continusly.

if one database had change, the other will also change

View 4 Replies View Related

Synchronize And Compare Two Database In Real Time

Sep 7, 2006

how to synchronize and compare two database in sql server 2000 without using any others software in real time.

my purpose is to check the two database in two different server if there has any different. And synchronize these two database continusly.

if one database had change, the other will also change

View 3 Replies View Related

Real-time Data Imports. How Stable Is It?

Feb 4, 2008

Hi there,

I was wondering about the stability of SSIS when it comes to importing data on a real-time basis. Let's say you have a scenario where flat files, for instance, will be dropped at random intervals ranging from 1 second to 10 seconds apart and the importer has to import these files immediately.

I would imagine that this is done with a package which runs a loop sniffing the directory forever but I stand corrected on the best ways of doing it.

I'm not too sure whether SSIS is a good idea for this as lots of people have had bad comments on SSIS in real-time in my company but they cannot elaborate on why enough to convince me. I have done some pretty cool stuff and must admit that I am a fan of the technology but dont want to defend it into a corner

Please give me your thoughts on this

Regards
Michael

View 13 Replies View Related

Real-Time Data Mining Discussion

Sep 27, 2006

I am about to prepare a paper concerning the field of real-time data mining. Real-time here means the process of incremental training of an existing model as soon as the data arrives.

There is a number of papers introducing algorithms for incremental association analysis, incremental clustering etc. Stream mining ís a field which is closely related to that. The main reason for the implementation of incremental algorithms is a) the large amount of data to be mined and b) the high rate of new data that is evolving every day.

Using classical batch mining algorithms, models that are outdated for some reason, would have to be re-trained, which could be very time consuming for billions of records. And once the training is completed, the training would have to be restarted once again because a bulk of new data has been arrived.

The question that I would like to discuss now is: For what real world applications would it be a meaningful or even essential to use real-time training of models?

Two main reasons could determine the answer to that question:

You just want to incorporate new data into existing models in order to increase the prediction accuracy of your model or
Your underlying data is subject to more or less massive changes (also refered to as concept drift) and you want to adapt your mining model continuously to that reality.

I'm looking for some examples or ideas where one of these cases apply and it would be a good idea to have incremental mining algorithms involved.

I'm looking forward to inspiring some discussion on that issue.

View 3 Replies View Related

Viewing The Result Of Predction With Time Series Algorithm In C#

Dec 17, 2007

hi to every one
and again i say my question
for the first time i thought if i ask my question from this forum i can give my answer exactly
but with these answers i see it was just a dream .
one person said you can see your answer in book with this title "the datamining with sql 2005 "but i cant find my request and then said you can find in datamning sql2005.com and in this site i cant find a sample about a form that i can show my result of prediftion with time series
i dont know how can i earn this code .and a sample about that .please please if every one can answer me ,answer with descripstion about code .i just want codes for connecting between c# and analysis serveice and a description about quality of this code,that means this code, how do it work?

View 1 Replies View Related

Real Time Live Data On A Windows Application .NET 2.0

Jan 10, 2006

I want to build a windows application in Visual Studio 2005 that grabs some data from a SQL DB and displays it in a gridview. That is easy and I already have it done, but I also want to know how to show this data in real-time. For example: right now we have a application that pulls some login information for all the users and displays their phone extension, their name, and their status. They can change their status by clicking on some radios below the datagrid and on change it updates the data and then posts back. However, I dont know how the guy who did it made it so that these local changes are automatically shown on everyone elses computers around the office. In other words, they are shown the live data as it changes, without having to refresh it or anything. How would I go about doing this or does anyone have any places/resources that could help me accomplish this task. Thanks.
Oh and the guy who wrote this is no longer working here and he deleted the source code so i cant look at it.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved