Is fn_dblog likely to cause any performance issues? So far it's 9 minutes & still running for the following:

SELECT top 1 *

FROM fn_dblog (NULL, NULL)

WHERE Operation = 'LOP_ABORT_XACT';

Edit: I...

Hi,

I feel this is unlikely because at the point there was 2,300 rows inserted the gap between first & last was 2.6 million (that's a lot of failed transactions); how...

OK thanks for the clarity. I guess I'll just add an extra step to fullscan on that particular table after doing an all-round sp_updatestats.

Could have sworn I already replied to this :f

The reason I have a hard time believing 1/2 are likely is because of the gap ranges. 7-8 times the sequence gaps...

Oh I see, thanks for the info. I will have to read up on XEvent as I haven't heard of it before.

Is there any kind of known bugs with the...

Ah I see haha, I guess that's why the difference is null (since the gaps).

Thanks.

GilaMonster (2/21/2014)

---

Ditch DTA. If you read the articles, I show how to identify the worst performance problems of what's in the trace, how to dig into the procedures and what...

Hehe no, on test. I restored a recent backup to test & moved the trace file to there (where...

Any idea why that trace wouldn't be read by DTA? Is there a size limit that it will support (trace is 3.4gb).

Also, why does RECONFIGURE take over 3 minutes (I...

Indeed :), that's the one I read before but it seems I need to increase the TextData column:

Msg 8152, Level 16, State 10, Line 1

String or binary data would be...

Hi Gail,

I cleared the stats yesterday & let them run to get a more accurate picture of the recent state. Using this Paul Randal query[/url] I get the following results:...

Hi Gail,

It was an object in tempdb so my assumption is that it would be that local temporary table created/dropped by the procedure because when I try OBJECT_NAME on the...

What Q...

I think it's all down to motivation. We have quite a large team (16 DBAs) where you can see juniors (1-2 years experience) who are better than a couple seniors...

Exactly, so wouldn't it be more likely to push out blocks from a query that returned 3 seconds earlier? Or is frequency a page is touched counted towards what becomes...