Posted by Tony Rogerson on 12/02/06 22:47

Rule of thumb for tempdb is one file per logical CPU.

Rule of thumb for application databases depends entirely on what you are
doing and the disk access pattern your queries create when they run - you
aim to service all queries from caching so its only the checkpoint /
lazywriter you need worry about.

--
Tony Rogerson
SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
Server Consultant
http://sqlserverfaq.com - free video tutorials


<justin.merth@gmail.com> wrote in message
news:1165095160.445609.172090@73g2000cwn.googlegroups.com...
> Is there any "rule of thumb" for determining how many files a database
> should be split into based on the size of the database or the number of
> CPUs?
>
> Thanks in advance for all of your advice
>

• Next in forum: Re: PLEASE PLEASE HELP - How can I get a return value from a SQL Stored Proc is ASP.NET?
• Prev in forum: Re: Table Partitioning on a RAID 5 Server
• Thread view: Re: Table Partitioning on a RAID 5 Server

[Reply to this message]