INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

How to resolve SQLDiag issue

How to resolve SQLDiag issue

(OP)
We have a Honeywell Experion 2003 Server whose sqldiag.txt grows very large and eats up all the space in the hard drive. In January of this year it grew to 170GB and we were unable to open it because it is always in use and too large. We deleted it then and referred the case to Honeywell. It is growing again and at 2GB right now. Does anyone know of this problem? What is causing it? And how to resolve it?The SQL Error logs also show Error 9002 Severity 17 State 6 and for waht its worth this server has shutdown (on its own) 4 times in the last 7 months.  
 

RE: How to resolve SQLDiag issue

(OP)
Oh and I know that Severity 17 means "Indicates that the statement caused SQL Server to run out of resources (such as memory, locks, or disk space for the database) or to exceed some limit set by the system administrator."  

RE: How to resolve SQLDiag issue

Is there a need to keep a query trace running constantly? If not, turn it off; could save lots of overhead.

RE: How to resolve SQLDiag issue

Forgot - you can also config the sqldiag utility.
Here is what MS has to say:

Quote:


The sqldiag utility gathers and stores diagnostic information and the contents of the query history trace (if running.) The output file includes error logs, output from sp_configure and additional version information. If the query history trace was running when the utility was invoked, the trace file will contain the last 100 SQL events and exceptions. sqldiag is intended to expedite and simplify information gathering by Microsoft Product Support Services.
Syntax

sqldiag
    [-?] |
    [-I instance_name]
    [ [-U login_ID] [-P password] | [-E] ]
    [-O output_file]
    [-X] [-M] [-C]
Arguments

-?

Displays usage information.

-I instance_name

Specifies the instance of Microsoft® SQL Server™ 2000 on the local server on which to connect. Omit the -I option to connect to the default instance on the local server.

-U login_ID

Is the user login ID. Login IDs are case-sensitive.

-P password

Is the password for the specified login_ID. If the -P option is specified at the end of the command prompt specifying password, sqldiag uses the default without password of NULL. Passwords are case-sensitive.

Security Note  NULL passwords are not recommended.

-E

Uses a trusted connection instead of requesting a password.

-O output_file

Redirects sqldiag output to the file named output_file. If the -O option is not specified, the output file name defaults to sqldiag.txt. In this case, the trace file names remain unchanged as blackbox.trc and blackbox_01.trc.

If the -O option is specified, sqldiag renames trace files blackbox.trc and blackbox_01.trc based on the name used for output_file (for example, if output_file is specified as MyDiagnostics.txt, the trace files will be renamed to MyDiagnostics.trc and MyDiagnostics_01.trc respectively).

Use of the -O option enables users to store several sqldiag outputs in the same directory.

-X

Excludes error logs.

-M

Performs DBCC stackdump.

-C

Retrieves cluster information.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close