Any way to tell what traces are running?

I have a stored proc where I create a SQL trace (using sp_trace_create). I
went onto one of my servers to fire off a trace and noticed that another one
has been running for a few days.
Is there any way to display the traces that are running on a particular
server? I would like to stop the old trace but I can't figure out how
Any help would be appreciated.
Thanks in advance.
TomIt figures - I was looking for this info all day yesterday. Right after
posting this, I finally discovered it.
The following SQL statement displays info on traces running
SELECT * FROM :: fn_trace_getinfo(default)
It seems that when I started the new trace, it was assigned TraceId=1 and
the old trace was bumped to TraceId=2. I then just issued the following to
kill trace 2:
EXEC sp_trace_setstatus 2, 0
EXEC sp_trace_setstatus 2, 2
"TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
news:#MUmQPzuDHA.1088@.tk2msftngp13.phx.gbl...
> I have a stored proc where I create a SQL trace (using sp_trace_create).
I
> went onto one of my servers to fire off a trace and noticed that another
one
> has been running for a few days.
> Is there any way to display the traces that are running on a particular
> server? I would like to stop the old trace but I can't figure out how
> Any help would be appreciated.
> Thanks in advance.
> Tom
>|||You can run from QueryAnalyzer statement DBCC TRACESTATUS (-1) , and you will see all traces that have been set
Something like
TraceFlag TraceStatu
1204
Hope it Helps

Any way to notify clients of DB changes?

Does anyone know of a way to notify clients of database changes in real-time? The clients are non-web clients on a WAN. I would like to fire real-time events in clients when specific data changes. I do not want to implement any type of polling scheme in the clients. Any input would be greatly appreciated!

EverettDo you want the notification to go through an email or an actual pop-up on their machine ? Under what conditions would you be sending this ?|||Use triggers?|||The notifications would be sent when specified data changes. I can fire a trigger when the data is inserted/updated/deleted, but how can I get this to the clients? I want to fire an event in a VB application, as opposed to sending out an email. For this reason, SQL mail or notification services don't seem to be the right tools to use.

Everett|||Probably write a COM object and fire a method via a trigger. Look up sp_OACreate in the Books Online.
Either that or an xp_commandshell and write a command line prog to do the same thing.

I KNOW the above two would work... If you wanted to get fancy, , you could probably also implement it by having a SQL second connection with read uncommited isoaltion leve that doesn't time out and have the trigger insert to a table that all of the clients are doing a never ending select from. This solution seems interesting, but, is most likely untrodden territory.

Originally posted by Ev Conrad
The notifications would be sent when specified data changes. I can fire a trigger when the data is inserted/updated/deleted, but how can I get this to the clients? I want to fire an event in a VB application, as opposed to sending out an email. For this reason, SQL mail or notification services don't seem to be the right tools to use.

Everett

Any load testing tool to test queries

Guys,

Is there any tool that can test the scalability of Analysis Services?

Basically we want to fire multiple queries to the Analysis Services and check if there is any performance degradation.

Is there any utility or tool that I can use?

Rgds

Hari

SQL Performance monitor works with SSAS too.|||

The Community samples site has an ASLoadSim tool listed which might be worth a look http://www.codeplex.com/SQLSrvAnalysisSrvcs