Re: How to set FILLFACTOR

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jéjé (willgart_at_BBBhotmailAAA.com)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 11:24:33 -0500

how many rows are inserted?

standard inserts ALWAYS use the log and this slow down your system. its not
recommended when you have to load a large amount of data.

the bulk inserts allow you to load your data by batch, for example by 50
000rows

another way to watch: your HD config! are you in Raid? (which one; how many
drives)
and how your HD buffer is configured?
have you a dedicated HD raid for your tempdb database?

your bottleneck can come another hardware limitation (not enough memory,
slow proc....)

"Nags" <nags@RemoveThishotmail.com> wrote in message
news:Ol09ZHa8EHA.2572@tk2msftngp13.phx.gbl...
>I use procedures to load the data and I use SQL Commands, like INSERT &
> UPDATE statements.
>
> -Nags
>
> "Thomas Kejser" <thomas@kejser.org> wrote in message
> news:OMA0vDN8EHA.824@TK2MSFTNGP11.phx.gbl...
>> Hi Nags
>>
>> What utility do you use to load the data into the tables?
>>
>> In order of load performance the follwing are the best utilities for SQL
>> 2000
>>
>> - BULK INSERT command
>> - DTS data pump with the correct settings
>> - BCP
>>
>> Though you would expect BCP to perform very good you can gain better
>> performance by using the BULK INSERT command - it seems that this
>> command
>> uses the netlib to bulk insert whereas BCP uses OLEDB
>>
>> Yours sincerely
>> Thomas Kejser
>>
>>
>>
>>
>
>

Relevant Pages

  • Re: How to set FILLFACTOR
    ... The source data is being brought thru replicated ... > I use procedures to load the data and I use SQL Commands, ... >> uses the netlib to bulk insert whereas BCP uses OLEDB ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: How to set FILLFACTOR
    ... I use procedures to load the data and I use SQL Commands, ... > Though you would expect BCP to perform very good you can gain better ... > performance by using the BULK INSERT command - it seems that this command ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: GRUB module query
    ... config screen for various RAID options - I turn them off and use kernel ... The whole interaction between BIOS, ... case a secondary "on card" bios, and then GRUB, and then Kernel. ... So on boot the BIOS conspire to load the ...
    (Ubuntu)
  • Re: Minimal configuration, suggestions wanted.
    ... Keep in mind that a server with a 200GB db and moderate load may not be the ... A RAID 0+1 will give the most fault tolerate Raid with good ... With a minimal configuration a good ... raid is essential along with proper backups. ...
    (microsoft.public.sqlserver.server)
  • Re: SSA Adapter Performance
    ... As said before, if you have considerable write I/O load, you better ... RAID 5 means that, for every single write, the ... Set up several arrays on your SSA loops (spread disks over both loops ... as a starting point in your considerations) so that the load is spread ...
    (comp.unix.aix)