Ahh! I have never used registered server window before. Now, I see I have missed a good functionality of SSMS all this while.

thanks Jeff.

Jeff

Thanks with your thoughts on Capacity Planning.

The drive only has all the mdf files of the several databases of the server. So just doing a backup/restore of all the...

Thanks Matt.

I'll wait for George is he is able to share the code to get the TempDB into 8 junior TempDBs!!

GSquared

Thanks.

Back to the main question, and in relation to fragmentation, we have a process where for a while we have had a truncation of log right after backup. What...

Matt

I do not need to plan any other process on the dedicated drive for TempDB. What I am asking is if SQL or Windows Server will need any extra space...

Jeff

Our 200 GB DB would take around 1.5 hours to backup & Restore. So I will work on scheduling that. The volume that this is on, says is 91% fragmented....

Is this equivalent to DTA (Database Engine Tuning Advisor) Index Requirement Analysis?

George, Yes, that is the biggest lesson after seeing that the data files is in 6000 distinct pieces: we will use sensible autogrowth or just allocate a bunch of space...

Jeff,

instant initialization is set up. So I can afford to go with a bigger number for autogrowth. But actually, If I have space (I have to check on this),...

Matt

Thanks for the tip. I like making additional data files out of TempDB; it can only help with I/O.

In my case, do you think I can set the TemPDB Size...

George,

Thanks for the article. It has lots of good queries to monitor on a peridic basis.

so you have set your TempDB to 32MB (4*8). If the TempDB should grow more...

CEWII

Thanks very much for your thought there. In the Servers where I have specific login under security, I will use your method.

Dan.

Grant

Do I have to install MOM only on the server or can I do it on a Client and monitor the server?

Right now I collect 30 parameters from PerfMon, and...

Sergey, Got it! thx.

Grant Fritchey

Is MOM where you right click on Object->Reports->Custom Reports->.rdl files to choose the report?

If yes, how do you store & analyze it?

Thanks for the idea of moving CSV to...