The Multifunctioning DBA

Jul 27 2011   8:00AM GMT

SQL Nexus

Colin Smith Colin Smith Profile: Colin Smith

I use SQL Nexus all the time to identify bottlenecks of my SQL Servers and I absolutely love the tool. I ran into a small issue though where I could not always load the *.trc files. It would start and fail very quickly and move on to importing the other data. While the tool was still useful it was not as useful as it is when the *.trc files import correctly. With them I can dig in and see the actual queries that were causing the issues. I found that the problem was my own. When I launched SQL Nexus I would create a new database for my traces and I would put a ‘_’ in the database name. It does not cause errors and is a valid database name but as soon as I took out the ‘-’ all my *.trc files will import with now issue.

hope that helps and happy troubleshooting

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: