Hi, I guess I have something wrong with my parallelism because it's looks like one CPU is working hard and all others is are sleeping. How can I...
Thanks for the answer. Do you think it's a best practice to split my DB in 8 files ? I was planning to create a BDTEMP in 8 files in 1 file groupe...
I have 2 X 4 Cores but it looks like one processor is working hard. I know one CPU is working on one file so i would like to know if it's a good idea...
With Dell, you can use/install Open Manage Server Administrator (need no reboot)
Thanks for that.Why I did't see any recommendation about spliting my database in 8 (2 * 4 threads = 8 threads) ?? All best pratice is talking only...
Hi !I read best practice on the web and I found this :It is recommended to have .25 to 1 data files (per filegroup) for each CPU on the host server....
Separate names with a comma.