July 17, 2008 at 10:39 am
Hi Im new to this subject and have done my reading on the msdn and some sites.
Would be grateful If somene could share the use of secondary filegroup of their database and how the layout is done ?
Also what is the advantages of using schema in sql 2005 and in what kind of scenario is it best used ? I heard my co-worker speak about the advantages of schema in terms of managing database objects ownerships, but I didn't quite get it .Thank You
July 17, 2008 at 10:44 am
what disk set up (RAID arrays, etc) are you using on your SQL server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 10:54 am
As I just joined this company as a Jr DBA .Im not very sure on the setup that they have but I would be great if you could give me an insight on what RAID has to do with this .Thanks
July 17, 2008 at 10:58 am
The advantage to separate filegroups is they can be on separate disks, if it's under a RAID configuration that allows that. If, for example, the whole database is on a single RAID-5 array, there's not much point to separate filegroups. On the other hand, if you have multiple RAID-1 arrays, then separate filegroups on separate arrays can be used to improve concurrent read/write capabilities.
On the question about schema, the whole idea is that different people/applications can have different schema, with the same table names, etc. Every time I've ever seen it used, or heard about it being used, it's been more of a problem than a solution. I recommend against it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 17, 2008 at 11:06 am
for a filegroup to be of any use it would need to be spread across a separate array to the primary filegroup. Cant see any advantage to creating filegroups and sticking them on the same physical disks.
Filegroups are designed to be spread across multiple disks, multiple disk controllers, or RAID arrays
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2008 at 7:27 am
Thank You guys...My doubts are clear now.:)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply