Monday, March 12, 2012

Heterogeneous queries and use of OLEDB providers are not supported

Hi all
I am trying to create linked server on 2005 64bit server for 2000 32 bit.
I ran instcat.sql script as microsoft article sugested.
Still, I am having problems.
I can browse db objects using management studio.
But when i try to run sql like:
select count(*) from botserver.master.dbo.sysobjects
I am getting:
Heterogeneous queries and use of OLEDB providers are not supported in fiber
mode.
I can neither run any stored procs.
My linked server is defined as server type: sql server
Any ideas?Why are you running in fiber mode in the first place? Unless you have a
very good reason for turning it on you should turn it back off and solve two
problems.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:DE0360F5-3A4C-47BB-9304-10D0FA789855@.microsoft.com...
> Hi all
> I am trying to create linked server on 2005 64bit server for 2000 32 bit.
> I ran instcat.sql script as microsoft article sugested.
> Still, I am having problems.
> I can browse db objects using management studio.
> But when i try to run sql like:
> select count(*) from botserver.master.dbo.sysobjects
> I am getting:
> Heterogeneous queries and use of OLEDB providers are not supported in
> fiber
> mode.
> I can neither run any stored procs.
> My linked server is defined as server type: sql server
> Any ideas?|||Hi Kelly
I have 8 cpu host and content switching is pretty high.
I read that these are indications to use light weight pooling.
If you can please educate me on this point too.
Thank you, Gene.
"Andrew J. Kelly" wrote:
> Why are you running in fiber mode in the first place? Unless you have a
> very good reason for turning it on you should turn it back off and solve two
> problems.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:DE0360F5-3A4C-47BB-9304-10D0FA789855@.microsoft.com...
> > Hi all
> > I am trying to create linked server on 2005 64bit server for 2000 32 bit.
> > I ran instcat.sql script as microsoft article sugested.
> > Still, I am having problems.
> > I can browse db objects using management studio.
> > But when i try to run sql like:
> > select count(*) from botserver.master.dbo.sysobjects
> >
> > I am getting:
> > Heterogeneous queries and use of OLEDB providers are not supported in
> > fiber
> > mode.
> >
> > I can neither run any stored procs.
> > My linked server is defined as server type: sql server
> >
> > Any ideas?
>|||Context switching being high is relative but is also usually caused by other
factors that can be addressed to ease this issue. Things like poorly
optimized queries, lack of proper indexes, poorly configured I/O subsystems,
too little memory, excessive blocking etc. Even other apps running on the
same server can cause excessive context switching. Switching to fiber mode
without addressing the root cause will only cause more problems in most
cases. And fiber mode is usually only really effective on systems with more
than 8 CPU's that are running at or near 100% utilization. I suggest you
concentrate on finding the real bottle necks and think seriously about
turning fiber mode off.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:13BBB927-0B8C-4479-8B01-6A9050DA9BF8@.microsoft.com...
> Hi Kelly
> I have 8 cpu host and content switching is pretty high.
> I read that these are indications to use light weight pooling.
> If you can please educate me on this point too.
> Thank you, Gene.
> "Andrew J. Kelly" wrote:
>> Why are you running in fiber mode in the first place? Unless you have a
>> very good reason for turning it on you should turn it back off and solve
>> two
>> problems.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Gene." <Gene@.discussions.microsoft.com> wrote in message
>> news:DE0360F5-3A4C-47BB-9304-10D0FA789855@.microsoft.com...
>> > Hi all
>> > I am trying to create linked server on 2005 64bit server for 2000 32
>> > bit.
>> > I ran instcat.sql script as microsoft article sugested.
>> > Still, I am having problems.
>> > I can browse db objects using management studio.
>> > But when i try to run sql like:
>> > select count(*) from botserver.master.dbo.sysobjects
>> >
>> > I am getting:
>> > Heterogeneous queries and use of OLEDB providers are not supported in
>> > fiber
>> > mode.
>> >
>> > I can neither run any stored procs.
>> > My linked server is defined as server type: sql server
>> >
>> > Any ideas?
>>|||Hi Andrew
Thank you for your information.
Here I have few questions if you would be interested to answer:
1. Do you think that fiber pooling is the real reason for linked server
problem
2. I have 2 similar servers: 8 cpu, 8gb of memory running 64 bit 2003
advanced server. They both do not run anything but 64 bit 2005 sql server.
One is very busy but cpu is close to 3-5% - plenty of queries but all
optimized and lightweight - mostly inserts and single value indexed selects.
cashe is 99%, no paging. Many hundreds processes access it.
Another server is just idling.
Both have 800 - 5000 contest switching all the time. Which i think is too
high.
Do you think it's normal or typical for given platform?
Thank you, Gene.
"Andrew J. Kelly" wrote:
> Context switching being high is relative but is also usually caused by other
> factors that can be addressed to ease this issue. Things like poorly
> optimized queries, lack of proper indexes, poorly configured I/O subsystems,
> too little memory, excessive blocking etc. Even other apps running on the
> same server can cause excessive context switching. Switching to fiber mode
> without addressing the root cause will only cause more problems in most
> cases. And fiber mode is usually only really effective on systems with more
> than 8 CPU's that are running at or near 100% utilization. I suggest you
> concentrate on finding the real bottle necks and think seriously about
> turning fiber mode off.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:13BBB927-0B8C-4479-8B01-6A9050DA9BF8@.microsoft.com...
> > Hi Kelly
> >
> > I have 8 cpu host and content switching is pretty high.
> > I read that these are indications to use light weight pooling.
> > If you can please educate me on this point too.
> >
> > Thank you, Gene.
> >
> > "Andrew J. Kelly" wrote:
> >
> >> Why are you running in fiber mode in the first place? Unless you have a
> >> very good reason for turning it on you should turn it back off and solve
> >> two
> >> problems.
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >> Solid Quality Mentors
> >>
> >>
> >> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> >> news:DE0360F5-3A4C-47BB-9304-10D0FA789855@.microsoft.com...
> >> > Hi all
> >> > I am trying to create linked server on 2005 64bit server for 2000 32
> >> > bit.
> >> > I ran instcat.sql script as microsoft article sugested.
> >> > Still, I am having problems.
> >> > I can browse db objects using management studio.
> >> > But when i try to run sql like:
> >> > select count(*) from botserver.master.dbo.sysobjects
> >> >
> >> > I am getting:
> >> > Heterogeneous queries and use of OLEDB providers are not supported in
> >> > fiber
> >> > mode.
> >> >
> >> > I can neither run any stored procs.
> >> > My linked server is defined as server type: sql server
> >> >
> >> > Any ideas?
> >>
> >>
>|||1. Yes Fiber mode has many restrictions and I am pretty sure that the
linked server issues you have are one of them.
2. 800 - 5000 context switching for an 8 processor server is not that much.
Especially if you have lots happening. That is no where even close to the
range that should be a consideration for fiber mode usage. Turn it off and
you will be much happier.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:4C7A457E-4176-49EC-8660-D7A95D689A04@.microsoft.com...
> Hi Andrew
> Thank you for your information.
> Here I have few questions if you would be interested to answer:
> 1. Do you think that fiber pooling is the real reason for linked server
> problem
> 2. I have 2 similar servers: 8 cpu, 8gb of memory running 64 bit 2003
> advanced server. They both do not run anything but 64 bit 2005 sql server.
> One is very busy but cpu is close to 3-5% - plenty of queries but all
> optimized and lightweight - mostly inserts and single value indexed
> selects.
> cashe is 99%, no paging. Many hundreds processes access it.
> Another server is just idling.
> Both have 800 - 5000 contest switching all the time. Which i think is too
> high.
> Do you think it's normal or typical for given platform?
> Thank you, Gene.
>
> "Andrew J. Kelly" wrote:
>> Context switching being high is relative but is also usually caused by
>> other
>> factors that can be addressed to ease this issue. Things like poorly
>> optimized queries, lack of proper indexes, poorly configured I/O
>> subsystems,
>> too little memory, excessive blocking etc. Even other apps running on
>> the
>> same server can cause excessive context switching. Switching to fiber
>> mode
>> without addressing the root cause will only cause more problems in most
>> cases. And fiber mode is usually only really effective on systems with
>> more
>> than 8 CPU's that are running at or near 100% utilization. I suggest you
>> concentrate on finding the real bottle necks and think seriously about
>> turning fiber mode off.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Gene." <Gene@.discussions.microsoft.com> wrote in message
>> news:13BBB927-0B8C-4479-8B01-6A9050DA9BF8@.microsoft.com...
>> > Hi Kelly
>> >
>> > I have 8 cpu host and content switching is pretty high.
>> > I read that these are indications to use light weight pooling.
>> > If you can please educate me on this point too.
>> >
>> > Thank you, Gene.
>> >
>> > "Andrew J. Kelly" wrote:
>> >
>> >> Why are you running in fiber mode in the first place? Unless you have
>> >> a
>> >> very good reason for turning it on you should turn it back off and
>> >> solve
>> >> two
>> >> problems.
>> >>
>> >> --
>> >> Andrew J. Kelly SQL MVP
>> >> Solid Quality Mentors
>> >>
>> >>
>> >> "Gene." <Gene@.discussions.microsoft.com> wrote in message
>> >> news:DE0360F5-3A4C-47BB-9304-10D0FA789855@.microsoft.com...
>> >> > Hi all
>> >> > I am trying to create linked server on 2005 64bit server for 2000 32
>> >> > bit.
>> >> > I ran instcat.sql script as microsoft article sugested.
>> >> > Still, I am having problems.
>> >> > I can browse db objects using management studio.
>> >> > But when i try to run sql like:
>> >> > select count(*) from botserver.master.dbo.sysobjects
>> >> >
>> >> > I am getting:
>> >> > Heterogeneous queries and use of OLEDB providers are not supported
>> >> > in
>> >> > fiber
>> >> > mode.
>> >> >
>> >> > I can neither run any stored procs.
>> >> > My linked server is defined as server type: sql server
>> >> >
>> >> > Any ideas?
>> >>
>> >>
>>|||Thank you Andrew, your advises were really helpfull.
"Andrew J. Kelly" wrote:
> 1. Yes Fiber mode has many restrictions and I am pretty sure that the
> linked server issues you have are one of them.
> 2. 800 - 5000 context switching for an 8 processor server is not that much.
> Especially if you have lots happening. That is no where even close to the
> range that should be a consideration for fiber mode usage. Turn it off and
> you will be much happier.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:4C7A457E-4176-49EC-8660-D7A95D689A04@.microsoft.com...
> > Hi Andrew
> >
> > Thank you for your information.
> > Here I have few questions if you would be interested to answer:
> > 1. Do you think that fiber pooling is the real reason for linked server
> > problem
> > 2. I have 2 similar servers: 8 cpu, 8gb of memory running 64 bit 2003
> > advanced server. They both do not run anything but 64 bit 2005 sql server.
> > One is very busy but cpu is close to 3-5% - plenty of queries but all
> > optimized and lightweight - mostly inserts and single value indexed
> > selects.
> > cashe is 99%, no paging. Many hundreds processes access it.
> > Another server is just idling.
> > Both have 800 - 5000 contest switching all the time. Which i think is too
> > high.
> > Do you think it's normal or typical for given platform?
> >
> > Thank you, Gene.
> >
> >
> >
> > "Andrew J. Kelly" wrote:
> >
> >> Context switching being high is relative but is also usually caused by
> >> other
> >> factors that can be addressed to ease this issue. Things like poorly
> >> optimized queries, lack of proper indexes, poorly configured I/O
> >> subsystems,
> >> too little memory, excessive blocking etc. Even other apps running on
> >> the
> >> same server can cause excessive context switching. Switching to fiber
> >> mode
> >> without addressing the root cause will only cause more problems in most
> >> cases. And fiber mode is usually only really effective on systems with
> >> more
> >> than 8 CPU's that are running at or near 100% utilization. I suggest you
> >> concentrate on finding the real bottle necks and think seriously about
> >> turning fiber mode off.
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >> Solid Quality Mentors
> >>
> >>
> >> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> >> news:13BBB927-0B8C-4479-8B01-6A9050DA9BF8@.microsoft.com...
> >> > Hi Kelly
> >> >
> >> > I have 8 cpu host and content switching is pretty high.
> >> > I read that these are indications to use light weight pooling.
> >> > If you can please educate me on this point too.
> >> >
> >> > Thank you, Gene.
> >> >
> >> > "Andrew J. Kelly" wrote:
> >> >
> >> >> Why are you running in fiber mode in the first place? Unless you have
> >> >> a
> >> >> very good reason for turning it on you should turn it back off and
> >> >> solve
> >> >> two
> >> >> problems.
> >> >>
> >> >> --
> >> >> Andrew J. Kelly SQL MVP
> >> >> Solid Quality Mentors
> >> >>
> >> >>
> >> >> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> >> >> news:DE0360F5-3A4C-47BB-9304-10D0FA789855@.microsoft.com...
> >> >> > Hi all
> >> >> > I am trying to create linked server on 2005 64bit server for 2000 32
> >> >> > bit.
> >> >> > I ran instcat.sql script as microsoft article sugested.
> >> >> > Still, I am having problems.
> >> >> > I can browse db objects using management studio.
> >> >> > But when i try to run sql like:
> >> >> > select count(*) from botserver.master.dbo.sysobjects
> >> >> >
> >> >> > I am getting:
> >> >> > Heterogeneous queries and use of OLEDB providers are not supported
> >> >> > in
> >> >> > fiber
> >> >> > mode.
> >> >> >
> >> >> > I can neither run any stored procs.
> >> >> > My linked server is defined as server type: sql server
> >> >> >
> >> >> > Any ideas?
> >> >>
> >> >>
> >>
> >>
>

No comments:

Post a Comment