in

ASP.NET Weblogs

This Blog

Syndication

.Coming Soon

Developer Book Reviews

Julia Lerman Blog

INETA Poster Child blabbing about community and code

Perf study on storing files in SQL Server vs. Hard drive

From October 2001 but still quite relevant, is a document on MSDN which is part of the Cold Rooster application where they worked out their decision to use SQL Server instead of the hard drive for file storage.

"Summary: Summarizes the study that was used to measure the performance difference between a database and a file system. It also explores the data modeling used to design the objects that support the ColdStorage sample Web Service hierarchical storage and infrastructure. (11 printed pages)"

It is a VERY useful "best practices" doc which I often point people to.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dncold/html/storagedbdsgn.asp

Comments

 

TrackBack said:

HumanCompiler
July 8, 2003 11:31 AM
 

Saeed tabrizi said:

HI
This Is saeed
can you help me on SQL SERVER 2000

my .ldf file is too big near than 850MB
but my .Mdf file is smaller than my .ldf file near than 190 MB.

can you help me ?
with thanks...
Saeed
sa_tabrizi@yahoo.com



October 11, 2003 10:16 AM
 

julie said:

Saeed-
I'm a terrible SQL Server administrator.
I recommend that you go to www.sqlservercentral.com. There are many many articles as well as forums.
Good luck.
Julie
October 13, 2003 9:24 AM

Leave a Comment

(required)  
(optional)
(required)  
Add