Data Import Speed | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Data Import Speed

We wish to set up a SQL Server that is updated overnight with data from a flat file ISAM database on a sco-unix system. Are there figures available that will allow me to calculate how long the import will take. We are talking Initially on about 3-4 Gb of data per night (although alot of the data will be replicated – at this stage doing a data compare is not viable). Eventually we will use SQL Server more efficiently, but thats later.
Unless you have tested the import procedure it is hard to say such values and using PERFMON you can assess such information Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Thanks for quick reply.
Initially we tested transfer of one data table (via SQL query) using SQL Server Developer Edition and the import wizard. So I suppose we could use the SQL generated by the wizard. I will also investigate PERFMON. As you can probably tell we are fairly new to SQL Server. Thanks again.
No worries you are in right place enhance your SQL knowledge, welcome to SSP forums. For optimum perforamance of data load you can use Bulk insert or having its format file correctly, also database recovery model should be switched to BULK_LOGGED. If you are using any UNICODE the format file should have the right collation to prevent unicode parsing. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx fyi though it talks about SQL2000 most of them applies to SQL 2005 too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>