If my database is 80GB's, how big should my Tempdb files be for a 2-quad core system?
My SQL 2005 Database is on Windows 2003 64bit OS with SQL 2005 64bit. My database is 80gigs and I am trying to figure out how to calculate the Tempdb file size. I have a dual Quad core system. I know that that I need an equal amount of files per processor, but I dont know how big they need to be.. i.e. 8 files at 10GB each for the tempdb. Any thoughts.