Saturday, August 3, 2013

[MS SQL Server] Profiler Trace duration?

[MS SQL Server] Profiler Trace duration?

Profiler Trace duration?

Posted: 02 Aug 2013 11:21 PM PDT

Hi,I have transfer data into table from trace file , after that i want check duration of praticulare events..I want to know as bleow query display how much milliseond or microsecond from trace table?SELECT TextData, Duration, CPUFROM trace_table_nameWHERE EventClass = 12 -- SQL:BatchCompleted eventsAND CPU < (Duration * 1000)thanksananda

Gaps in tlogs

Posted: 03 Aug 2013 02:19 AM PDT

Ok, so here's the issue. We have a report server database that has been correctly been updating tlogs for years. A couple days ago, we shrunk the live database/log, and now we continue to receive "gaps" in the tlogs. Does anyone have any suggestions on how to resolve this? Should we somehow restore the entire report server database with the live database...and the tlog shipping will just kick in from there??

Sql server 2008 R2 --- procedure Cache

Posted: 09 Aug 2011 02:17 AM PDT

HiWe have a sql server 2008 R2 on physical server with RAM-- 512 gb.we have around 300 gb of data in disk, the sql server memory has been set to 485gb.sql server is using around 300gb of the memory.the question here is, the plan cache hit ratio is only 65%.can u please help me resolve this and increase the plan cache hit ratio to 100%we are doing around 7000 batches/secwe have enabled optimize for ad-hoc workloads to true and forced parameterization.thanks for the help,
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog