Viewing 14 posts - 346 through 360 (of 360 total)
Yes, I tried to open it and it opened fine. Now I see that it shows the file size. I think its showing the size after the specified time has...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 7, 2011 at 11:53 pm
Lowell,
I already stopped the trace by executing
exec sp_trace_setstatus @trace_id,0
@traceid in this case is 2, and when executed I get the result command executed successfully. but the file size is still...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 7, 2011 at 3:54 pm
Also, I set the end time to a later time in the code that I used for tracing. But had to stop trace in the middle (before actual complete time...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 7, 2011 at 11:10 am
Also, when i query select * from sys.traces the status column shows 0 for my trace that has id as 2.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 7, 2011 at 10:38 am
Just an FYI...I have the total index size as 30GB and I have increased my transaction log size to 50GB.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 6, 2011 at 8:22 pm
Hi Kubicek,
I have written a cursor that identifies all the indexes on tables that are not being used. Interesting in our case nothing showed up. The results were blank on...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 6, 2011 at 6:49 pm
Thanks for your reply...I will do some reading on how B-tree structures store data.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 6, 2011 at 2:33 pm
Thank You.
One more thing...can we increase the trace file size while the trace is running?
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 3, 2011 at 1:08 pm
Thanks Guys...I have cancelled the ones I used earlier...i will be running it with switches after hours
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 3, 2011 at 10:05 am
I cancelled the DBCC CHeckDB query ...does it impact anything?
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
October 3, 2011 at 8:18 am
Is there a way to find the actual executable that is using the sql authentication in connection strings.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 29, 2011 at 9:15 am
Thanks Lowell...I am able to see from a host ".Net SqlClient Data Provider" as the program name logged multiple times...so is that the actual application?
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 28, 2011 at 3:03 pm
Thank you...i will try and get back to you
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 28, 2011 at 2:15 pm
Thanks much for your responses...I was actually looking to identify if there is a way I can capture the connection strings of those applications when they hit the database :-D...
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
September 28, 2011 at 1:03 pm
Viewing 14 posts - 346 through 360 (of 360 total)