Okay.

No schedule

How...

I didn't use a token so I can't say for sure.

Because of the VLFs issue, I'm assuming it was the log reader.

Brandie Tarvin (8/15/2014)

---

I think it would help us to know what your replication set up is.

What type of replication?

What is the latency / timing?

Approximately how many subscriptions do...

I'll will do that. But why? What is this based on?

I pregrow the files to an appropriate size (sounds like 256GB may need to be considered). But I avoid the multiples of 4GB and will go with 4000MB or 8000MB...

Triple checked. Definitely 8192 MB.

Just changed it to 8000 MB.

Thanks for responding.

253952.230 is the size we wanted. (To avoid log growths)

Has been great for a long time.

But the log needed to grow this morning.

253952 / 8192 = 31 growths

277494...

anthony.green (8/7/2014)

---

Only other one would be to test your TTL on the DNS entry, you will want to flush your DNS cache on all machines so that it picks up...

Go to SQLServerCentral.com/forums (Skip Google)

Post the question

Bump every 10 mins until...

To get an idea on the rows sizes, something like this will help.

SELECTT.Name, SUM(Max_Length) [Aproximate row size in bytes]

FROMsys.Columns C

INNER JOIN sys.Tables T

ON C.[object_id] = T.[object_id]

WHERET.name IN ('Tbl1', 'Tbl2', 'Tbl3',...

Thanks for the reply Gazareth.

Jes Schultz Borland's[/url] article says you can have OR in filtered indexes, but in the comments Aaron Bertrand corrects this. Apart from your comment I have...

Great article!

This helped me find a bunch of overlapping indexes.

Besides the is_Disabled flag, I'd also include the has_filter flag and filter_definition as well.

Most of the duplicates I found had filters.

When...

Thanks for the input guys.

Sorry for the late post back. Priorities shift a lot here.

(Haven't even starting testing backups yet! Sorry Grant. I'll get to it. I promise.)

I'd...

Jonathans query only returns 8 queries.

OptimizationLvlSubTreeCostusecountssize_in_bytes

FULL250.4238131072

FULL11.585498673728

FULL909.892473728

FULL25.4864163840

FULL112.03424106496

FULL364.273561131072

FULL402.357308229376

FULL231.654594483328

Looks like I need to start tweaking.

Thinking MAXDOP 5, Threshold 10

Maybe a simple question, but how can I best measure the changes?

Can I make...

Thanks for help guys.

Jack Corbett (5/2/2014)

---

Jonathan Kehayias has a query in this blog post[/url] that finds parallel plans in the cache so you could compare your results to...