Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

SQL Log and Database Files

What is the reccomended size of the SQL Log and Database files. I am trying to decide where I need to store my files and on what partation to store them.

Any help would be useful

Thanks

2 REPLIES
New Member

Re: SQL Log and Database Files

You might want to take a look at "White Paper: Physical Storage Best Practices for Cisco Unity with Microsoft Exchange," http://www.cisco.com/univercd/cc/td/doc/product/voice/c_unity/whitpapr/storage.htm.

Scott

New Member

Re: SQL Log and Database Files

there is no "recommended" size for transactions logs .ldf or databases .mdf in SQL server. SQL Server autoshrinks databases that have a large amount of free space. Only those databases where the autoshrink option has been set to true are candidates for this process. The server checks the space usage in each database periodically. If a database is found with a lot of empty space and it has the autoshrink option set to true, SQL Server reduces the size of the files in the database. You can also use SQL Server Enterprise Manager or the DBCC SHRINKDATABASE and DBCC SHRINKFILE statements to shrink the files of a database manually.

Files are always shrunk from the end. For example, if you have a 5 GB file and specify 4GB as the target_size in a DBCC SHRINKDB statement, SQL Server will free as much space as it can from the last 1 GB of the file. If there are used pages in the part of the file being released, SQL Server first relocates the pages to the part being retained. You can only shrink a database to the point where it has no free space remaining. For example, if a 5GB database has 4 GB of data and you specify 3 GB as the target_size of a DBCC SHRINKDATABASE statement, only 1 GB will be freed.

If a DBCC SHRINKDATABASE or DBCC SHRINKFILE statement cannot reclaim all the space in a log file, the statement will issue an informational message indicating what action you must perform to make more space eligible to be freed

like with exchange, deciding which partition to put transaction logs on or separating transaction logs from the database files means NOTHING unless they are different PHYSICAL disks. I you have this luxary, then by all means take advantage of it.

"You might want to take a look at "White Paper: Physical Storage Best Practices for Cisco Unity with Microsoft Exchange," "

i guess this white paper would be informative however since he was asking about SQL it would be less so in this case. SQL, while having some paralells with exchange, is a different database.

Exchange transaction logs grow to 5mb and then a new one is created and so on where SQL maintains one continuous transaction log. Exchange transaction logs are truncated with a full database backup where obviously SQL's are not.

Your best bet with unity in my opinion is to leave things how they are unless you can move the transaction logs to a different physical disk or physical array

then your .mdf's and still you will not really notice a difference since you will not be constantly accessing data from this database like you would with a SQL server that was serving another enterprise data storage role.

261
Views
0
Helpful
2
Replies