.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links


Posted By:      Posted Date: October 27, 2010    Points: 0   Category :Sql Server

Hi, not sure if the question is directed to the correct forum, plase let me know if not.

Hello I was hoping that someone can clarify the SQL Server FILESTREAM usage in N-TIER architecture.

I have concern on performance with N-Tier architecture. I am considering refactoring an application with the following physical tiers (Rich Client -> Web Service - > Database), currently all the files a stored on the web service tier.

If clients need to download files (2 MB – 50 MB), the files will need first to be transfer from the DB server tier to the Web Service tier and then transfer from the Web Service tier to the client tier.

It’s seem a lot of network overhead using FILESTREAM compare to local file stored on the web service tier local disk, do you have any performance experience on the real impact in the above scenario using FILESTREAM .

Any opinion would be much appreciated.

View Complete Post

More Related Resource Links

how to upload files (5MB-50MB) into sql server 2008 by using filestream

Hi!i have some files, and i need to upload these files into sql server 2008 by using filestream.lets take table name as custfiles,              columns are fileid,filename,filepath,filesize.1.how to create table using filestream?2.how to insert file (record) into table from .net environment?3.how to retrive that file from .net environment?please provide related code....THANS FOR ANY HELP

How to serialize a File using Filestream

Is there a way to serialize a file using File stream. If no how it can be done Any one please help

Store XML in XML type field or using FILESTREAM

(Posted this in Database Design, but then thought I should post here as well)   Hi All,   I am trying to figure out what would be the best method for storing xml documents in the db...if we should use an XML type field or if we should use the newly introduced FILESTREAM? We would have a need to shred those documents for queries and possibly use the FULL TEXT SEARCH to allow for user defined searches on those documents.  Does anyone have any thoughts on either approach for SQL server 2008?    Always apprecaite the input I get on this forum...very helpful.   --B

FILESTREAM in sql compact

I'm try to create a table that contains blob(in sqlce case, it's IMAGE) and using the FILESTREAM attribute 1) although i do find the doc on sql server 2008 ( e.g. VARBINARY(MAX) FILESTREAM ), but i couldn't find any on sqlce. I did try using IMAGE FILESTREAM, but it didn't work. Any idea? 2) From the doc., sql server 2008 seems to create a file in the file system. However in sqlce, does it mean any insertion to this table, will lead to creation of a file in the filesystem? 

Performace Issues in WF

HI, I have desgined a WF, which scans 40k rows and do some logic. After doing 5k rows, I am getting an error: Attempted to read or write protected memory. This is often an indication that other memory has been corrupted What is this? Is it because of heavy load of data to workflow?

SQL Reporting Service 2005 - share schedule report performace T-SQL query?

Hi, I have SQL 2005 reporting services Shared Schedules and each schedule has its own subscribed report. I would like to have T-SQL 2005 to find out performance loading on each schedule. i.e. MySchedule_1 has 10 reports in it and AVEGARE report eaxecutiontime is like 3mins 5sec      MySchedule_2 has 7 reports in it and AVEGARE report eaxecutiontime is like 4mins 9sec Pls can I have T-SQL 2005 on ReportServer database to find out load on each schedules (and more drill-down to each report level for execution time)?

Performace point/Excel services OLAP cubes

Running Sharepoint 2010 Ent fresh install.  I have created a new site and performance point service as instructed in the following tutorial. http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx I have then uploaded an Excel document which pulls data from OLAP cubes.  The Excel doc as a standalone works fine.  After it has been uploaded users can open it as normal etc but when changing slicers and trying to pull info from the cubes I get the following error.. An error occurred durning an attempt to establish a connection to the external data source.  The following connections failed to refresh: "Name of out cubes here" I have been playing with the secure store and generating keys etc to no avail.  I have tried exporting the .odc file from the Excel document and uploading it to the data connections library/dashboard site but this doesnt help The anoying thing is that I had it working once and then the next day it failed for no apparent reason and even after a fresh install I cant get it to work again.  Any pointers or tutorials would be greatly appreciated! Andy

impact of enabling filestream

Hi I have a SQL 2008 R2 setup question: Currently we have SQL 2008 R2 installed and having sharepoint 2010 foundation running its dataabse in the SQL 2008 R2.  I would like to enable filestream base on http://msdn.microsoft.com/en-us/library/cc645923.aspx .  The document didn't say if a restart of the sql engine needed or not.  Since this sql has sharepoint running on it already for a week and is live.  I would like to know the impact of those steps to sharepoint.  Any suggestion?  Thx, Ted.

Restoring 2008 Database with Filestream - Process cannot access file error

I'm trying to restore a copy of a database that has a filestream and am getting the error below. I've tried with move option to specify a new path and left it with default path, neither worked. Did a trace with procmon, didn't see anything. FileStream1 is a new folder that the restore process creates. I've deleted the folder, tried it with a new name, re-took the backup from the source machine, restarted SQL, rebooted the machine, drive permissions are open. I've run out of ideas on how to debug further. Looking up the error online wasn't much help either. Msg 3634, Level 16, State 1, Line 1 The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'OpenFile' on 'X:\Data\FileStream1\4ecb2e48-0eee-4c99-a3f0-f1e6c7f00b24\f2efe374-9481-4c1b-a7f2-dcdcee350807\0000001b-0000aaa6-00f6'. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. ' SQL Server 2008 SP 1, MS Server 2008 R2 Server

filestream datatype

What is the difference between :enable filestream for  t-sql statement and  enable filestream for file i/o streaming access in sql 2008 when and how both feature works?

Error installing RBS with the FILESTREAM provider

I had intalled RBS on the web application according to this guids http://technet.microsoft.com/en-us/library/ee748631.aspx. In rbs_install_log I can find the message "Product: SQL Remote Blob Storage -- Configuration completed successfully". But I get also the error in same logfile "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections." In content Database no rbs tables have been created.  I try the command line with DBINSTANCE=<instancename> und DBINSTANCE=<servername\instancename>, but I get always the same error. Has anyone the same issue?

Filestream column

Hello, On a Visual Studio 2010 database project I created the following table: CREATE TABLE [dbo].[Resources] ( [Id] INT IDENTITY (1, 1) NOT NULL, [Content] VARBINARY (MAX) FILESTREAM NULL, [Description] NVARCHAR (800) NULL, [Key] UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL, [Locked] BIT NOT NULL, [Name] NVARCHAR (100) NOT NULL ); I keep having the error: SQL04141: A table with FILESTREAM column(s) must have a non-NULL unique ROWGUID column. But I do have such a column: Key What am I doing wrong? Thanks, Miguel  

Can't enable filestream on SQL Server 2008 Express 64bit under Win 7(64 bit WOW)

I have a newbie question.  I am running Win7(64 bit WOW). I installed SQL Server 2008 Express R2 (64 bit), but when I go to enable filestream, it reports that my edition of SQL Server does not support filestream.  I thought that the 64 bit edition would.  It says to install SQL Server 2008 64 bit.  Am I correct that that is not a free download?  Do I have any other options?

Filegroup, File and FileStream

Hello, I have a database with four tables and all of them have a FileStream field. I know I can create one or more Filegroups and inside each filegroup create one or more files. How should I distribute them? I mean, should I have one filegroup for the database and one file inside that filegroup for each table? And how to specify in each table which file to use? Thanks, Miguel

FILESTREAM will not enable in R2

I'm having a problem creating a database with FILESTREAM.  The CREATE DATABASE command blows out telling me that FILESTREAM is not enabled.  I enabled it during the installation and received no install errors.  I've gone to Config Manager and checked that it was enabled.  I disabled it in Config Manager, restarted the instance, enabled it, restarted again.  Still nothing.  I've run sp_configure and get no errors.  The config value is 2, but the run value stays at 0, no matter what I do.  Anyone have any ideas?Mike Hotek mhotek@mssqlserver.com

Restoring 2008 Database with FileStream - CreateFile Sharing Violation

I've previously posted this question and turning off the anti-virus scan helped fix it. But I'm having same issue on a machine that doesn't have anti virus scanning enabled. Back story: I'm trying to restore a copy of a database that has a filestream and am getting the error below. I've tried with move option to specify a new path and left it with default path, neither worked.  Also tried the with replace option. FileStream1 is a new folder that the restore process creates. I've deleted the folder, tried it with a new name, re-took the backup from the source machine, restarted SQL, rebooted the machine, drive permissions are open. Msg 3634, Level 16, State 1, Line 1 he operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'OpenFile' on 'R:\Data\FileStream1\4ecb2e48-0eee-4c99-a3f0-f1e6c7f00b24\f2efe374-9481-4c1b-a7f2-dcdcee350807\0000001b-00005fcf-005a'. RESTORE DATABASE is terminating abnormally. ' I found the file on filemon and below is the error, stack and processes running. Date & Time:    9/15/2010 6:33:48 PM Event Class:    File System Operation:    CreateFile Result:    SHARING VIOLATION Path:    R:\Data\FileStream1\4ecb2e48-0eee-4c99-a3f0-f1e6c7f00b24\f2efe374-9481-4c1b-a7f2-dcdcee350807\

How do you filestream read a group of bytes instead of byte by byte?

If the following code is seeking to a specific byte of the file, then reading it byte by byte... then how do Itell it to read a group of bytes ?  for example, I want to read 10 bytes at a time and store into some char array.thanksfileStream.Seek(0, SeekOrigin.Begin); //seek to first byte ch = (char) fileStream.ReadByte(); Console.WriteLine("First value is " + ch);
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend