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 «««1234»»

*** HUGE SQL Server Problem *** =( Expand / Collapse
Author
Message
Posted Monday, May 12, 2014 12:28 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:32 PM
Points: 19, Visits: 55
Hi Robert,

In the Events tab, under "Available Event Classes - TSQL", I selected "TSQL - SQL: StmtStartiing" and added it the "Selected event classes"

In the Filters tab, how to I filter for an alter database statement? Please see screenshots at http://bit.ly/1oCRgLh




Post #1570020
Posted Monday, May 12, 2014 1:21 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 8:16 AM
Points: 1,618, Visits: 1,554
The query text will be in the TextData column. So on the Filters tab, enter a filter of LIKE 'ALTER DATABASE' for the TextData column.



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1570037
Posted Monday, May 12, 2014 4:36 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:32 PM
Points: 19, Visits: 55
The trace is running now ... how long should I run it for?


Post #1570088
Posted Monday, May 12, 2014 4:41 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 8:16 AM
Points: 1,618, Visits: 1,554
Until the database is changed to single user again.



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1570089
Posted Tuesday, May 20, 2014 1:04 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:32 PM
Points: 19, Visits: 55
Hi Robert,

The DB changed to single-user mode again, and I downloaded all the trace .trc files. How do I use these files to find out what caused the single-user problem again?



Post #1572846
Posted Tuesday, May 20, 2014 1:24 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 8:16 AM
Points: 1,618, Visits: 1,554
Look at the commands (TextData column) and other relevant columns in the trace files using either the SQL Profiler tool or by querying the files directly with the built-in system function fn_trace_gettable().



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1572863
Posted Tuesday, May 20, 2014 4:19 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:32 PM
Points: 19, Visits: 55
I opened the trace file in SQL Profiler and entered:

Search value: alter table
Data column: <All columns>

but it didn't return any results. Also the text data column is always blank.



Post #1572942
Posted Saturday, May 24, 2014 8:06 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:32 PM
Points: 19, Visits: 55
The server keeps going into single-user mode. Please help.


Post #1574353
Posted Saturday, May 24, 2014 9:49 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 8:16 AM
Points: 1,618, Visits: 1,554
Can you post the trace files?



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #1574355
Posted Sunday, May 25, 2014 1:57 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:32 PM
Points: 19, Visits: 55
Robert Davis - the files are confidential. I will send you a PM. Thank you in advance for your help.


Post #1574407
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse