Grant Fritchey (11/4/2016)

---

I don't know if you're on 2008 or 2008R2, but if the latter, you should explore using traceflag 2371. It makes a huge difference for lots of people...

@jeff - Completely agree, stats are absolutely necessary. I use below code to check when were the stats last updated, i am not 100% satisfied on the results...

Apologies, didn't provide more details.

My original question was how do you maintain statistics, are you using table partitioning or some thing else.

In addition to what Gail has mentioned, have you seen any sporadic I/O issues?

Couple options:

i) You could may be just try restoring from a differential if you are concerned restoring from a full backup.

ii) You could try replaying old logs to see...

Yes.

Depends on what you are doing. If you just want to know status of all the backup jobs across all servers you could just use built in Registered servers task....

PB_BI (8/23/2016)

---

curious_sqldba (8/22/2016)

---

I haven't really played with memory settings on SSAS engine so is the question. Under the properities it is set to 65 and 80 for Lowmemory and totalmemory...

Have you googled? Would have taken you less time...

Lynn Pettis (8/9/2016)

---

curious_sqldba (8/9/2016)

---

I am subscribed to these groups:

Current SubscriptionsNotification

Home » SQL Server 2008 » SQL Server 2008 Performance Tuning

Instant

Home » SQL Server 2014 » Administration - SQL Server 2014

Instant

Home...

I am subscribed to these groups:

Current SubscriptionsNotification

Home » SQL Server 2008 » SQL Server 2008 Performance Tuning

Instant

Home » SQL Server 2014 » Administration - SQL Server 2014

Instant

Home » SQL Server...

Yeah from SSC . The SPAM is coming from SSC. I am subscribed to many topics, not sure which one is it coming from. But looks like the topic does...

Sean Lange (7/28/2016)

---

curious_sqldba (7/28/2016)

---

I have looked online and on this forum but couldn't find exactly what i am looking for. I need a script that will dump definition of all...

Good catch, i fixed my original comment. Yes i mean you...

The main...