January 4, 2008 at 2:03 am
Hi,
We here have a db of 1.5 Tb using 26 datafiles, is there any way to know how the datafiles are used ? They are all setup as primairy. I didn't setup the files, I'm just trying to help a sysadmin ;-). By the way it's a navision db, has anyone any info about navision on sql server with large db's ? For all I know in NL it's one of the largest setups for a navision db.
I'm also looking for info about the actual mapping of the sql datafiles, something simular like a map that a disk defrag program shows. Any lead's will be usefull, I already own the karen delany book but this didn't supply the info i needed..
regards,
Wim
Wim van den Brink
January 4, 2008 at 6:09 am
You want to take a look at the catalog views, like sys.database_files which will give you hard information about the files themselves, or dynamic management views, like sys.dm_db_file_space_usage which will go into more details about the number of pages used by a given file. You can also look at the catalog view sys.data_spaces linked to other catalog views like sys.tables to see which objects are being stored in which file group. From there... Have fun.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply