 | |
Gobal variable causes performance degradation?
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Gobal variable causes performance degradation? -
02-07-2006
, 06:01 AM
#2
| |||
| |||
|
|
Hello to everybody I'm using SQL Server 2000 (sp3) I created a package on the server which uses a global variable . When I run the package( from DTS Designer) it takes almost 1 minute to return 6 rows . I went to take a look at an execution plan and made sure that an optimizer used INDEX SEEK and it took in QA if I run the query - 0 sec What is going on? Can someone shed light on the problem? Thanks |
#3
| ||||
| ||||
|
|
Where is the time being taken? |
Actually it does not matter how I call the package, running from DTS
designer takes the same time
Quote:
|
What task are you using? |
OrderId=?)
Quote:
|
What type of Connection are you using? |
Note: I just did some testing on my workstation to run the same SELECT but
against Orders in Northwind and it took 0 sec
I mean also from DTS Designer it ran very fast , but on our server it takes
to much time
Thanks again
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote
Quote:
|
Hello Alexl, Where is the time being taken? What task are you using? How are you using it? What type of Connection are you using? Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hello to everybody I'm using SQL Server 2000 (sp3) I created a package on the server which uses a global variable . When I run the package( from DTS Designer) it takes almost 1 minute to return 6 rows . I went to take a look at an execution plan and made sure that an optimizer used INDEX SEEK and it took in QA if I run the query - 0 sec What is going on? Can someone shed light on the problem? Thanks |
#4
| |||
| |||
|
|
Hi, Allan It is very good to see you here right now. Where is the time being taken? I have a SP that calles DTS Package (It is taken from SQL Server Profiler) Actually it does not matter how I call the package, running from DTS designer takes the same time What task are you using? I have one simple table with 100 rows (SELECT remarks FROM Table where OrderId=?) What type of Connection are you using? OLEDB Provider with Mixed Authetication Note: I just did some testing on my workstation to run the same SELECT but against Orders in Northwind and it took 0 sec I mean also from DTS Designer it ran very fast , but on our server it takes to much time Thanks again "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:f0343b0314b788c7f9f6494296a0 (AT) msnews (DOT) microsoft.com... Hello Alexl, Where is the time being taken? What task are you using? How are you using it? What type of Connection are you using? Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hello to everybody I'm using SQL Server 2000 (sp3) I created a package on the server which uses a global variable . When I run the package( from DTS Designer) it takes almost 1 minute to return 6 rows . I went to take a look at an execution plan and made sure that an optimizer used INDEX SEEK and it took in QA if I run the query - 0 sec What is going on? Can someone shed light on the problem? Thanks |
#5
| |||
| |||
|
|
Contention for resources etc What did you mean by this? |
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote
Quote:
|
Hello Alexl,. Then we need to check what is different between the server and your workstation MDAC, Contention for resources etc If the package runs fine on your PC as you expect then it is not necessarily DTS that is at issue here. Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hi, Allan It is very good to see you here right now. Where is the time being taken? I have a SP that calles DTS Package (It is taken from SQL Server Profiler) Actually it does not matter how I call the package, running from DTS designer takes the same time What task are you using? I have one simple table with 100 rows (SELECT remarks FROM Table where OrderId=?) What type of Connection are you using? OLEDB Provider with Mixed Authetication Note: I just did some testing on my workstation to run the same SELECT but against Orders in Northwind and it took 0 sec I mean also from DTS Designer it ran very fast , but on our server it takes to much time Thanks again "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:f0343b0314b788c7f9f6494296a0 (AT) msnews (DOT) microsoft.com... Hello Alexl, Where is the time being taken? What task are you using? How are you using it? What type of Connection are you using? Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hello to everybody I'm using SQL Server 2000 (sp3) I created a package on the server which uses a global variable . When I run the package( from DTS Designer) it takes almost 1 minute to return 6 rows . I went to take a look at an execution plan and made sure that an optimizer used INDEX SEEK and it took in QA if I run the query - 0 sec What is going on? Can someone shed light on the problem? Thanks |
#6
| |||
| |||
|
|
Hi,Allan MDAC's version is the same Contention for resources etc What did you mean by this? "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:f0343b0314c228c7f9fed1a82d00 (AT) msnews (DOT) microsoft.com... Hello Alexl,. Then we need to check what is different between the server and your workstation MDAC, Contention for resources etc If the package runs fine on your PC as you expect then it is not necessarily DTS that is at issue here. Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hi, Allan It is very good to see you here right now. Where is the time being taken? I have a SP that calles DTS Package (It is taken from SQL Server Profiler) Actually it does not matter how I call the package, running from DTS designer takes the same time What task are you using? I have one simple table with 100 rows (SELECT remarks FROM Table where OrderId=?) What type of Connection are you using? OLEDB Provider with Mixed Authetication Note: I just did some testing on my workstation to run the same SELECT but against Orders in Northwind and it took 0 sec I mean also from DTS Designer it ran very fast , but on our server it takes to much time Thanks again "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:f0343b0314b788c7f9f6494296a0 (AT) msnews (DOT) microsoft.com... Hello Alexl, Where is the time being taken? What task are you using? How are you using it? What type of Connection are you using? Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hello to everybody I'm using SQL Server 2000 (sp3) I created a package on the server which uses a global variable . When I run the package( from DTS Designer) it takes almost 1 minute to return 6 rows . I went to take a look at an execution plan and made sure that an optimizer used INDEX SEEK and it took in QA if I run the query - 0 sec What is going on? Can someone shed light on the problem? Thanks |
#7
| |||
| |||
|
|
Hello Alexl, Is there anything between the server and the data that is different to your workstation and the data? Is the server pegged for memory/CPU/Disk? That kind of thing Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hi,Allan MDAC's version is the same Contention for resources etc What did you mean by this? "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:f0343b0314c228c7f9fed1a82d00 (AT) msnews (DOT) microsoft.com... Hello Alexl,. Then we need to check what is different between the server and your workstation MDAC, Contention for resources etc If the package runs fine on your PC as you expect then it is not necessarily DTS that is at issue here. Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hi, Allan It is very good to see you here right now. Where is the time being taken? I have a SP that calles DTS Package (It is taken from SQL Server Profiler) Actually it does not matter how I call the package, running from DTS designer takes the same time What task are you using? I have one simple table with 100 rows (SELECT remarks FROM Table where OrderId=?) What type of Connection are you using? OLEDB Provider with Mixed Authetication Note: I just did some testing on my workstation to run the same SELECT but against Orders in Northwind and it took 0 sec I mean also from DTS Designer it ran very fast , but on our server it takes to much time Thanks again "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:f0343b0314b788c7f9f6494296a0 (AT) msnews (DOT) microsoft.com... Hello Alexl, Where is the time being taken? What task are you using? How are you using it? What type of Connection are you using? Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com Hello to everybody I'm using SQL Server 2000 (sp3) I created a package on the server which uses a global variable . When I run the package( from DTS Designer) it takes almost 1 minute to return 6 rows . I went to take a look at an execution plan and made sure that an optimizer used INDEX SEEK and it took in QA if I run the query - 0 sec What is going on? Can someone shed light on the problem? Thanks |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.