Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Traces Expand / Collapse
Author
Message
Posted Monday, June 30, 2014 7:47 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 1:49 PM
Points: 58, Visits: 332
I have discovered some traces that are consuming space on an old server running sql server 2000.

I found them by running:

SELECT * FROM ::fn_trace_getinfo(NULL)

1 1 1
1 2 NULL
1 3 5
1 4 2014-07-01 09:37:17.000
1 5 1
2 1 1
2 2 NULL
2 3 5
2 4 2014-07-01 09:37:17.000
2 5 1


I am able to close/stop them, but they continue to come back...how do i stop them completely?? They consume about 10gb a month.

Thanks
Post #1587636
Posted Monday, June 30, 2014 8:22 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:56 AM
Points: 2,439, Visits: 2,976
If they re-appear automaticly, they could be started by an SQL Agent job or perhaps by an application (like a monitoring application). You need to find out the process that starts the trace(s).
In SQL2000 there is no default-trace like there is in SQL2005+, so the running traces are not required by SQL itself.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1587652
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse