topic Re: Tuning SQL Server Load Speed in QlikView

Tuning SQL Server Load Speed

Thu, 21 Feb 2013 17:37:39 GMT

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

flipside — Fri, 22 Feb 2013 10:41:21 GMT

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

Fri, 22 Feb 2013 14:51:07 GMT

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

Fri, 22 Feb 2013 14:52:57 GMT

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

Re: Tuning SQL Server Load Speed

danielrozental — Fri, 22 Feb 2013 16:28:54 GMT

There is probably some network setting connections messed up in your server, have someone technical check them out.