How to handle issues of performance when using openrowset to import data ? RRS feed

  • Question

  • I have 20 users using server my database SQL server 2012 

    they imports  data using openrowset as insert to tables

    the problem server is hanging too much time to execute queries

    I using openrowset to import data from excel then show final result on excel .

    some times more users work on same time on same tables 

    some users import 10000 records or more to database 

    I mean Import is insert or update using openrowset

    I have may be 40 importers on database 

    I attached sample as one i have may be 40 importers as attached

    but different tables

    may be some users use same import on same time 

    may be some importers have more data importer schema


    what is best scenario for treat with multi thread ?

    are openrowset is good for treat big data or what ?

    I can accept any thing advice to enhance performance 

    if they are any thing alternative and good i accept it

    Thursday, January 16, 2020 1:55 AM

All replies