.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

Multiple tempdb file size

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

Hello there,

I am little bit confused about multiple tempdb files.

Suppose i want to place tempdb on its own disk of 100 gb, and want to set the size of tempdb to 100 gb. So in near future it probably do not need to autogrow. To impliment multiple tempdb file i.e. 8 (as per MS recommendation), because we have 4 quadra core processor that is total 16 processors. So how to set size for 8 tempdb file.

Pl provide detail with step.




View Complete Post

More Related Resource Links

Upload Multiple File using JQuery in asp.net

In this article I have explained how to upload multiple files using file upload control. I have used jQuery plugin for uploading multiple files.

I have also explained how to check for file type, file maximum size limit using jQuery & also using server side validation code.

Toolbox: Easy File Backup, Exploring Files And Folders Inside Visual Studio, Multiple Monitor Softwa


If the responsibility for creating, managing, and executing routine backups is yours, these tools will make it easier. Also see how you can browse folders and files from inside Visual Studio.

Scott Mitchell

MSDN Magazine May 2009

Using the single *.rpt file with multiple data sources


I've created a set of CrystalReports (*.rpt files) for an ASP.NET web app on a development server. I call each report using the following code:

protected void BTN_RunReport_Click(object sender, ImageClickEventArgs e)
CrystalReportViewer_ClientLetter.Visible = true;

ConnectionInfo con = new ConnectionInfo();
con.ServerName = Constants.ServerIP;
con.DatabaseName = Constants.DatabaseName;
con.UserID = Constants.UserID;
con.Password = Constants.Password;

CrystalReportViewer_ClientLetter.ReportSource = Server.MapPath(Constants.ClientLetters);
ParameterFields parameter = CrystalReportViewer_ClientLetter.ParameterFieldInfo;
ParameterField batchdate = new ParameterField();
batchdate.Name = "@BatchDate";
ParameterDiscreteValue batchdate_value = new ParameterDiscreteValue();
batchdate_value.Value = Convert.ToDateTime(txtBatchDate.Text);

foreach (TableLogOnInfo tlf in CrystalReportViewer_ClientLetter.LogOnInfo)
tlf.ConnectionInfo = con;

Log file size question

I recently setup transaction log backups after we had a log file get near its capacity. I noticed after log files are truncated, they still use up the same amount of disk space. Is it safe to shrink a log file?  If so how do you determine what is an appropriate size to shrink it to? I ask this because some databases, like a sharepoint content database, have log files that are 130 GB in size when their data files are only 5 GB.  I assume that now that I am running hourly log backups they dont need logg files that huge. -Edit - Also most of the logg files are setup with the default settings

Error using multiple webconfigure file in ASP.Net 3.5

when i using mutiple webconfigure file in .net 3.5 ,error Comes t is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level.  This error can be caused by a virtual directory not being configured as an application in IIS.

SSIS multiple data flows accessing the same raw file

I have multiple data flow tasks accessing the same raw file at virtually the same time.  I would like to know if the data flow tasks lock the raw file during read?  Can multiple data flow tasks read the same raw file at the same time.  I'm currently developing with a very small data set, but I would like to know if I should be concerned with the possibility of the data flow tasks competing for access to the same raw file. Thanks.

ssis 2008 Loading MULTIPLE EXCEL file

HI it is possible for me to load multiple text file using for each loop,but if i try the same process for EXCEL file then my excel source throws an error. Also when i created my variable in value  i have given the path of my excel file ,still it didnt help me..because the moment i map the variable with the connection string of source excel connnection(property->expression->connection string) it start giving error if you could help me or provide some reference it will be of great help http://bi-polar23.blogspot.com/2007/08/loading-multiple-excel-files-with-ssis.html i tried this link but got stuck with it on step 12 and 14 (below  is my connection string) and variable is @Filename which i have created Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\mushtaq.sheikh\Desktop\ForEach\New Microsoft Excel Worksheet1.xlsx;Extended Properties="Excel 12.0;HDR=YES"; The moment i try to edit my connection string by comparing connection string provided in link it gives error(an OLEBD error has occured with error code 0x80040E73) on excel source Thanks in advance

Multiple File Uploads and blocked file types.

Hi hopefully someone can help me with this. I have removed a few file type extensions from the blocked file type administration interface (.ascx, ashx, dll) etc. If I browse to my shared folder I am able to load files of these types into my shared folder on a file by file basis, if however I try and use the drag and drop activex control facility for multiple files provided for IE8, files of these types are still blocked. If I also map a network drive from my PC to the shared folder and attempt to copy files of the above types, they're also being blocked. Perhaps someone has come across a similar issue and can shed some light on what they did to overcome this problem. Kind regards Paul

tempdb file locks

We have an application which has heavy usage of temp tables. I'm trying to sort out what kind of lock issues this can present. So I did a test where I created a temp table and then inserted 100.000 rows in it: declare @counter int     set @counter = 0     while @counter < 1000000     begin       set @counter = @counter + 1       insert into #tmp values('test','test','test',NULL,NULL)     end At the same time I executed sp_lock to see what happens. What I see is that an X lock of type FIL appears. So, this means that every insert creates a database file lock on the tempdb? Doesn't sound that good.    

file size increase when moving from file system to sharepoint 2007

Hi, While moving files from file system to Sharepoint 2007 via windows explorer view, why do file sizes increase? thanks, Burcu  

tempdb not pointing to the correct .mdf file in SQL 2008

We had to restore our master.mdf file. Now when I right click on the properties of the tempdb it shows the path to the tempdb as pointing to the master.mdf file with a logical name of master. I have tried runnng the alter database command and it completes fine. The new tempdb.mdf file is created in the new location but when I go back in to look at the properties in SQL manager it stilll shows as pointing to the master.mdf file. How can I change? Any help would be greatly appreciated.   Steve

How can I reduce the .sql file size?

The program in our office has program called eSRE. My Database server is called Wamp Server. In Wamp Server there is a MySql 5.0. MySql is my Database. Now, I already encode a lot of records in my database. When my computer encounter an error, I backed up my database and has named of lgusresystem.sql with 3,895KB. Now, after I reprogrammed my computer and reinstalled the said program, I imported such backed up database file (lgusresystem.sql) into a MySql Server but the computer prompt a message like this "No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration". Here in MySql Server, I can see here that the maximum file to be imported is only 2,048KiB. So, what am I going to do so that I can restore my latest records in my database? I hope you will give an appropriate immediate action on this matter. Thank you very much.   JEFFREY R. DAWATON from Philippines  

check file size before uploading process in c# with asp.net


Hi All,

Thank you for Advance.

currently we are configured execution Timeout="1200" (The default is 110 seconds)  and maxRequestLength="12288"  (The default is 4096 KB)

but some times users upload files above 12MB so we are getting "Maximum request length exceeded" error.

we are checking the file size using client side javascript ActiveXObject object. but ActiveXObject only works in IE not in others like mozilla,crome,...

Jacescript Code are

function GetSize(file)
  var fso=new ActiveXObject("Scripting.FileSystemObject");
  var f=fso.getFile(file);
  return fso.getFile(file).size;


how can i check the file size before uploading process with support all the browser.

any posiblities for checking file size before server side script/object?


How to merge sheets from multiple excel files into one .xls file?


 I have several excel spreadsheet fils, each of them contains multiple work sheets that may storing images or data.

 How could I merge all of these work sheets to just one .xls file and keep their original layout and style using asp.net?

 Thanks in advance.

Multiple databases backup/restore in a transaction, if possible, into only one file


Hi dear,

I have three databases named XDW, XOLTP, XOLTPSchema. All of these are for only one application. In the application, user should do backup/restore using GUI.


1. How I should do backup/restore in one transaction? i.e. all of three actions should be success elsewhere all of them should fail.

2. Is it possible to backup them into only one file e.g. X.bak?

3. Or, What is the standard solution in this condition?

Thanks in advance.

How To: Joining multiple DataTable using “LINQ to DataSet”

How can I shrink the size of LDF file after BACKUP LOG?


Ive just done BACKUP LOG against particular database and found no changes in size for the appropriate LDF file. It is shrunk only after I issue:







But this approach breaks all logs chain. Is there any way to shrink the LDF file for FULL backup model without destroying the whole sequece of log backups?

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