Posted by Greg D. Moore \(Strider\) on 03/12/07 19:14

"rcamarda" <robert.a.camarda@gmail.com> wrote in message
news:1173725223.934126.197140@30g2000cwc.googlegroups.com...
> With help of others on this group, I've been learning and researching
> about indexes; an area I neglected.
> I see I can specify which filegroup I wish to create an index, which
> the default is Primary.
> I have more than one drive in my SQL server where I put data and logs
> on their own logical raid groups.
> My databases are SIMPLE, so they dont use much, if any logs (none as I
> understand).
> I was thinking of adding an additional file to my database and use it
> solely for the indexes.
> Any thoughts?
>

Yes, I've done this and putting your non-clustered indexes in its own group
can provide an improvement. Especially for rebuilds and the like.

HOWEVER, your database most definitely DOES use the logs. SIMPLE simply
means that as soon as transactions are complete, the log is truncated so it
won't grow. But it is definitely being used.

Keep in mind that w/o logs, you seriously hamper your disaster recovery
options. Since you're running SQL Server Enterprise, that makes me suspect
this is more than just a little test site.


> SQL Server 2005 Enterprise x64 SP2
> 8 disk SAS Raid 1+0 w/ 512mb ram w/ battery backup.
> Thanks,
> Rob
>

--
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com

[Back to original message]