Evil Craig ----

All very good ideas. I'll try some of them and see if the Junior DBA will be appropriate too.

Barkingdog

P.S. Are you any relation to the famous "Dr....

Is the order (DBCC spaceusage, UPDATE STATISTICS) in which they are run of importance?

BD

Thanks to everyone for their help!

BD

Is there any value to running "DBCC updateusage" in addition?

Barkingdog

Good article. I would appreciate it if someone could bring me up to speed on this point: Does PowerShell itself (v 3.0?), or a third-party product, offer PowerShell debugging...

I am also removing the "Rebuild Index" option of the maintenance plan. I'll read Ola's artice to see if\when I need to run his script. (I have a feeling that...

GliaMonster,

I looked at the job in greater detail. They

1) check database integrity (All databses). That's good

2) Shrink datbases (All user databases),. Free space: 10%

3) Rebuild Indexes ("original amount of...

GilaMonster,

I think when the Maintenance PLan was setup they simply selected all options..... no one thought about the consequences. You remark

>>>

About the only thing you can do to reduce...

Scott,

I just looked at the sql server agent job. Her it is!

>>>

C:\Program Files\NetApp\SnapManager for SQL Server\SmsqlJobLauncher.exe new-backup –svr '<ServerName>'

-RetainBackupDays 3 -lb -bksif -RetainSnapofSnapInfo 8 -updmir –mgmt...

Scott,

Just read your article:

http://blogofshaw.blogspot.com/2011/07/skinny-on-snapmanager-for-sql-server.html

Oy vey is my summary.

Because the whole NetApp SMSQL setup is unfamiliar to me I am still using our RedGate backup to backup the databases nightly. ...

Scott,

Your replies are numbered. Mine are indented.

1. Only the job configuration is stored in SMSQL (everything in SMSQL is stored in a flatfile - this is why it is soooo...

Scott,

Our company just installed SnapManager for SQL last week. (I have never used the product before, I'm not familiar with their distinction bewteen aggregate, Volume, and LUN, but as...

Bitbucket,

Truth be told we actually have many apps (written in different languaes) that import differerent format files and apply their own processes to each file. So it's not really as...

Dev,

Thanks for the great answer. I have never used Analysis Services and had no idea how to answer this question.

Barkingdog

I never heard of SchemaSurf but I just checked it out and it looks very intriguing.

Thanks,

Barkingdog