4 Replies Latest reply: Feb 22, 2013 11:28 AM by Daniel Rozental RSS

    Tuning SQL Server Load Speed

      I have a script to load from a large SQL Server table 7+ million rows.  The extract takes 15 minutes from my desktop, but when I run the extract on the qlikview server it takes 3 hours.  Does anyone have any ideas.

       

      Additional Info:

       

      Qlikview is the only application running with no other DBs on the server (e.g. Oracle or DB2).  The script runs fine on my laptop so I don't believe that SQL Server itself is the problem.  At the time of the script run, it was the only connection on the server.  I was hoping that there is a setting on the ODBC connection or OLE on the Qlikview server that is causing this delay.

        • Re: Tuning SQL Server Load Speed
          Dave Riley

          Difficult to say without knowing more about the server config.  Here's some initial thoughts ...

           

          Is the Qlikview server running any other applications?

          What DB connections are you using (ODBC/OLEDB)?

          Are the DSNs configured the same?

          Is the Qlikview server behind a firewall?

          Is the server running data connection at same time as another process on the SQL box?

          Connection pooling issues?

           

          ... think that's it for starters !

           

          I would monitor from SQL server side first.

           

          flipside

          • Re: Tuning SQL Server Load Speed

            Answers to the questions posted;

             

            No - Qlikview is not running any other applications including another database (e.g. Oracle, DB2)

            Qlikview is behind the firewall with the database, also my laptop which is also behind the firewall runs fine.

            There aren't any other connections running at the time that I ran the script.  No sure about connection pooling, will follow-up with the DBA group,  I think SQL Server is fine because the script on my laptop runs in a good time.

            • Re: Tuning SQL Server Load Speed

              Qlikview is the only application running on the server.  There aren't other database connections (e.g. Oracle or DB2) on the server.  I think SQL Server is fine because the script on my laptop runs fine (15 minutes).  The connection was the only one runnning at that time so I don't believe connection pooling is an issue