Distribution of temp db in multiple files

Question

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 

Answer 1

now sure if this is what you are looking for...

ButtonAddOrder_Click(...) 

{ 

THIS IS THE CODE I HAVE: StreamWriter myWriter new StreamWriter("customer.txt"); MyWriter.WriteLine(txtName.Text); MyWriter.Close(); 

If(addOrder == DialogResult.yes) 

{ why dont you call a function here...like myfunc() } 

}

Myfunc()

{

 DO COMMON TASK HERE

}

Answer 2

great that it worked for you, also you are not stupid ; any question big or small is legit.

Answer 3

I think I know what you mean... I Create a Function or Procedure then call it in both the button and if statement!!! Thanx man!!! Lol, I'm stupid....

Answer 4

Hi Dillion,

you question is not clear, may be you can elaborate more or give us some examples. For what i understand is you want to write a common routine and you want to call that on any event, like button click, etc. So I am not sure if you just create a Sub/Function and pass the object as the parameter and run your routine based on the object's decision.