Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
7
Reply
Distribution of temp db in multiple files
Manish Kumar
Sep 27 2016 4:49 AM
265
Reply
HI All,
I recently got one task for distribution of tempdb load to multiple ndf files. I found some tips like based on number of processor we can make ndf files.
My question is
--Does it require any down time for a higly used OLTP database, just by simply writing alter command for adding a file group.
--How can i make sure traffics are distributed equally to all files (.mdf and .ndf)
--Any new suggestions.
Thanks,
Manish
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
7
)
Next Recommended Forum
How to pass schema and table name in store proc
If column is not present in table How to apply sum function