This fairly old whitepaper on index maintenance recommends skipping maintenance for indexes smaller that 1000 pages.

1000 pages * 8Kb per page =...

This is the whois record:

Domain Name: HOWTOSQL.COM

Registry Domain ID: 1665756602_DOMAIN_COM-VRSN

Registrar WHOIS Server: whois.tucows.com

Registrar URL: http://tucowsdomains.com

Updated Date: 2015-06-07T18:52:58Z

Creation Date: 2011-07-07T18:50:49Z

Registrar Registration Expiration Date: 2016-07-07T18:50:49Z

Registrar: TUCOWS, INC.

Registrar IANA ID: 69

Registrar Abuse Contact...

Try to take more frequent log backups during the rebuild process. You could take log backups every 1 minute and put a delay of 1 minute between each table rebuild.

Reorganize could help, but I can't tell how much.

Another possibility is BCP the data to a file, drop the table and BCP the data back in. Index rebuild does almost...

Only 20 MB of log activity means that the database is close to unused. Thus, indexes don't need to be rebuilt.

Ola Hallengren has a database maintenance script that takes fragmentation...

How big is the index? If the index is very small, you have very few chances of getting low fragmentation.

Brandie Tarvin (11/5/2015)

---

BWFC (11/5/2015)

---

Woolly nebulous request of the month alert.

I've been asked to look into ad-hoc reporting solutions so users can create their own reports.

All I know is it's a...

Why do you think you need an additional disk?

What problem are you trying to solve?

I'm sorry to say that and I mean no offense, however: you're doing it wrong.

1) Set up a subscriber on your machine and subscribe to that publication.

2) Start the...

I'm sorry, there is not enough information to answer your question.

If you want sensible answers and fast turnaround on your questions, see the instructions here[/url].

Great!

Thanks for the feedback

I don't think that index fragmentation is your problem. MsMerge% tables are based on GUIDs and will always be fragemented.

I would rather try to trace a sync process with a...

You probably don't need to filter on the client side (powershell script). The filter on the session could be enough.

The event you have to capture is "errorlog_written" and filter for...

I don't know how to help you then.

Do you have one of those subscribers available for troubleshooting?

Can you set up a subscriber (your desktop computer would do as...

I don't see a problem with that. The source is trustworthy.

Will probably work with 2014 as...