Using File Groups
-
We have a SQl server 2000 production Database installed on NT4.
From last few days the database is going very slow.
Can I achieve some performance benefits by moving certain related tables on different
Filegroups.
He who knows others is learned but the wise one is one who knows himself.
He who knows others is learned but the wise one is one who knows himself. -
quote:
Can I achieve some performance benefits by moving certain related tables on differentFilegroups.
if these filegroups are on the same physical disk, I don't think you get a boost in performance, if at all.
However, placed on separate disks there should be an increase.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
If I need to move existing tables to other filegroups, How do I do them?
I mean do I have to do it explicitly?
Like Create a table on other file group then transferring data from the old table and so on.
or is there any simpler method?
He who knows others is learned but the wise one is one who knows himself.
He who knows others is learned but the wise one is one who knows himself. -
quote:
or is there any simpler method?
EM?
No, serious, look at BOL for files and file groups
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
I am not sure if it can be done using EM
I think I am missing something obvious.
Can u guide me frank?
He who knows others is learned but the wise one is one who knows himself.
He who knows others is learned but the wise one is one who knows himself. -
One way I found is using the database diagrams.
There one can change the file groups.
He who knows others is learned but the wise one is one who knows himself.
He who knows others is learned but the wise one is one who knows himself. -
quote:
I am not sure if it can be done using EM
I think I am missing something obvious.
Can u guide me frank?
He who knows others is learned but the wise one is one who knows himself.
In EM right click on the table in question-Design Table->right click ->properties-> Table filegroups...
however, I donot only use filegroups for performance reasons.
It's the only way in SQL 7 and SQL2k to backup a only parts of a db.
One might consider this reaon also.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
quote:
From last few days the database is going very slow.Can I achieve some performance benefits by moving certain related tables on different
Filegroups.
Are you sure it was caused by I/O? You need monitor the system using performance monitor and SQL Server Profiler to find out where are the exactly the slowness cause.
-
I'll go with Allen_Cui, first try and determine what is causing the problem
Reminder: Make sure your backups have been done regularly, just in case.
-
Another benefit of seperating your tables/indexes to different file groups is the possibility of getting multiple threads to the disks. Like Frank said, if they are all on the same disk chances are your performance is not going to improve, but your disk configuration could be a factor as well.
"Keep Your Stick On the Ice" ..Red Green
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply