w had an auditing team running Microsoft Assessment on our database servers . This product recommends that the principle of creating ONE datafile per cpu be
deployed on all the SQL Servers regardless of the load on the server . How can Microsoft release a product like this ?
such advice had appeared from top consultants who work on very big and heavy farms. They suggested to improve the number of files per cpu only after analysing wait statistics and contention GAM and SGAM pages(can't recall exact terminology). We should be careful with what we choose. Read some whitepapers from SQLCAT team, PSSQL team, blogs from Paul Randal,Brent Ozar and analyse what they suggest before we make this implementation in our production servers.