profiler and showplan

I turn on profiler Performance/Execution Plan, and expect to see the
plan in the textdata field - but it's not there.
Is there some event class or other field or something that must also
be included that I've missed?
Thanks.
Josh
Which SQL profiler template have you selected? One of the template (standard)
displays TextData field.
Thanks
GYK
"JXStern" wrote:

> I turn on profiler Performance/Execution Plan, and expect to see the
> plan in the textdata field - but it's not there.
> Is there some event class or other field or something that must also
> be included that I've missed?
> Thanks.
> Josh
>
|||On Wed, 27 Oct 2004 16:03:02 -0700, GYK
<GYK@.discussions.microsoft.com> wrote:
>Which SQL profiler template have you selected? One of the template (standard)
>displays TextData field.
I am capturing/displaying the textdata field, but it's empty on the
showplan lines, and in the statement lines I still see just the
statements. I used the SQLProfilerStandard template, and one of my
own, didn't seem to matter. I added all the TSQL events, that didn't
help either.
J.
[vbcol=seagreen]
>Thanks
>GYK
>"JXStern" wrote:
|||You have to capture the Binary Data to see the Showplan output.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:9ta0o0d664jpr8ihme1kb2kngna64f721q@.4ax.com...
> On Wed, 27 Oct 2004 16:03:02 -0700, GYK
> <GYK@.discussions.microsoft.com> wrote:
> I am capturing/displaying the textdata field, but it's empty on the
> showplan lines, and in the statement lines I still see just the
> statements. I used the SQLProfilerStandard template, and one of my
> own, didn't seem to matter. I added all the TSQL events, that didn't
> help either.
> J.
>
>
|||On Wed, 27 Oct 2004 16:27:33 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>You have to capture the Binary Data to see the Showplan output.
Wait a minute. I changed the template to capture BinaryData field,
and sure enough, now I got the Showplan tree - in the TextData field!
So I removed the BinaryData field, and now I *still* get the Showplan
tree in the TextData field. Even after I exit and restart Profiler!
Is this some weird bug in SQL2K, that you have to first ask for the
BinaryData, then you can stop asking for it, to get the Showplan tree?
Weird.
But it worked, so thanks!
Josh
|||That IS weird. When I remove the binary data column I don't get the showplan
anymore.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:ebf0o0pldmaluufjgic4lstkb6ovectqob@.4ax.com...
> On Wed, 27 Oct 2004 16:27:33 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
> Wait a minute. I changed the template to capture BinaryData field,
> and sure enough, now I got the Showplan tree - in the TextData field!
> So I removed the BinaryData field, and now I *still* get the Showplan
> tree in the TextData field. Even after I exit and restart Profiler!
> Is this some weird bug in SQL2K, that you have to first ask for the
> BinaryData, then you can stop asking for it, to get the Showplan tree?
> Weird.
> But it worked, so thanks!
> Josh
>
|||What event are you capturing... showplan or execution plan?
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:ebf0o0pldmaluufjgic4lstkb6ovectqob@.4ax.com...
> On Wed, 27 Oct 2004 16:27:33 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
> Wait a minute. I changed the template to capture BinaryData field,
> and sure enough, now I got the Showplan tree - in the TextData field!
> So I removed the BinaryData field, and now I *still* get the Showplan
> tree in the TextData field. Even after I exit and restart Profiler!
> Is this some weird bug in SQL2K, that you have to first ask for the
> BinaryData, then you can stop asking for it, to get the Showplan tree?
> Weird.
> But it worked, so thanks!
> Josh
>
|||On Wed, 27 Oct 2004 17:58:04 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>What event are you capturing... showplan or execution plan?
Execution plan.
J.
|||On Wed, 27 Oct 2004 17:48:58 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>That IS weird. When I remove the binary data column I don't get the showplan
>anymore.
But when you get it, is it in the binary or text field?
|||JXStern wrote:
> On Wed, 27 Oct 2004 17:58:04 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
> Execution plan.
> J.
Execution Plan only requires TextData. Show Plan, if I'm not mistaken,
requires BinaryData.
David Gugick
Imceda Software
www.imceda.com
sql

profiler and showplan

I turn on profiler Performance/Execution Plan, and expect to see the
plan in the textdata field - but it's not there.
Is there some event class or other field or something that must also
be included that I've missed?
Thanks.
JoshWhich SQL profiler template have you selected? One of the template (standard
)
displays TextData field.
Thanks
GYK
"JXStern" wrote:

> I turn on profiler Performance/Execution Plan, and expect to see the
> plan in the textdata field - but it's not there.
> Is there some event class or other field or something that must also
> be included that I've missed?
> Thanks.
> Josh
>|||On Wed, 27 Oct 2004 16:03:02 -0700, GYK
<GYK@.discussions.microsoft.com> wrote:
>Which SQL profiler template have you selected? One of the template (standar
d)
>displays TextData field.
I am capturing/displaying the textdata field, but it's empty on the
showplan lines, and in the statement lines I still see just the
statements. I used the SQLProfilerStandard template, and one of my
own, didn't seem to matter. I added all the TSQL events, that didn't
help either.
J.
[vbcol=seagreen]
>Thanks
>GYK
>"JXStern" wrote:
>|||You have to capture the Binary Data to see the Showplan output.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:9ta0o0d664jpr8ihme1kb2kngna64f721q@.
4ax.com...
> On Wed, 27 Oct 2004 16:03:02 -0700, GYK
> <GYK@.discussions.microsoft.com> wrote:
> I am capturing/displaying the textdata field, but it's empty on the
> showplan lines, and in the statement lines I still see just the
> statements. I used the SQLProfilerStandard template, and one of my
> own, didn't seem to matter. I added all the TSQL events, that didn't
> help either.
> J.
>
>
>|||On Wed, 27 Oct 2004 16:27:33 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>You have to capture the Binary Data to see the Showplan output.
Wait a minute. I changed the template to capture BinaryData field,
and sure enough, now I got the Showplan tree - in the TextData field!
So I removed the BinaryData field, and now I *still* get the Showplan
tree in the TextData field. Even after I exit and restart Profiler!
Is this some weird bug in SQL2K, that you have to first ask for the
BinaryData, then you can stop asking for it, to get the Showplan tree?
Weird.
But it worked, so thanks!
Josh|||That IS weird. When I remove the binary data column I don't get the showplan
anymore.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:ebf0o0pldmaluufjgic4lstkb6ovectqob@.
4ax.com...
> On Wed, 27 Oct 2004 16:27:33 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
> Wait a minute. I changed the template to capture BinaryData field,
> and sure enough, now I got the Showplan tree - in the TextData field!
> So I removed the BinaryData field, and now I *still* get the Showplan
> tree in the TextData field. Even after I exit and restart Profiler!
> Is this some weird bug in SQL2K, that you have to first ask for the
> BinaryData, then you can stop asking for it, to get the Showplan tree?
> Weird.
> But it worked, so thanks!
> Josh
>|||What event are you capturing... showplan or execution plan?
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:ebf0o0pldmaluufjgic4lstkb6ovectqob@.
4ax.com...
> On Wed, 27 Oct 2004 16:27:33 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
> Wait a minute. I changed the template to capture BinaryData field,
> and sure enough, now I got the Showplan tree - in the TextData field!
> So I removed the BinaryData field, and now I *still* get the Showplan
> tree in the TextData field. Even after I exit and restart Profiler!
> Is this some weird bug in SQL2K, that you have to first ask for the
> BinaryData, then you can stop asking for it, to get the Showplan tree?
> Weird.
> But it worked, so thanks!
> Josh
>|||On Wed, 27 Oct 2004 17:58:04 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>What event are you capturing... showplan or execution plan?
Execution plan.
J.|||On Wed, 27 Oct 2004 17:48:58 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>That IS weird. When I remove the binary data column I don't get the showpla
n
>anymore.
But when you get it, is it in the binary or text field?|||JXStern wrote:
> On Wed, 27 Oct 2004 17:58:04 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
> Execution plan.
> J.
Execution Plan only requires TextData. Show Plan, if I'm not mistaken,
requires BinaryData.
David Gugick
Imceda Software
www.imceda.com

profiler and showplan

I turn on profiler Performance/Execution Plan, and expect to see the
plan in the textdata field - but it's not there.
Is there some event class or other field or something that must also
be included that I've missed?
Thanks.
JoshWhich SQL profiler template have you selected? One of the template (standard)
displays TextData field.
Thanks
GYK
"JXStern" wrote:
> I turn on profiler Performance/Execution Plan, and expect to see the
> plan in the textdata field - but it's not there.
> Is there some event class or other field or something that must also
> be included that I've missed?
> Thanks.
> Josh
>|||On Wed, 27 Oct 2004 16:03:02 -0700, GYK
<GYK@.discussions.microsoft.com> wrote:
>Which SQL profiler template have you selected? One of the template (standard)
>displays TextData field.
I am capturing/displaying the textdata field, but it's empty on the
showplan lines, and in the statement lines I still see just the
statements. I used the SQLProfilerStandard template, and one of my
own, didn't seem to matter. I added all the TSQL events, that didn't
help either.
J.
>Thanks
>GYK
>"JXStern" wrote:
>> I turn on profiler Performance/Execution Plan, and expect to see the
>> plan in the textdata field - but it's not there.
>> Is there some event class or other field or something that must also
>> be included that I've missed?
>> Thanks.
>> Josh
>>|||You have to capture the Binary Data to see the Showplan output.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:9ta0o0d664jpr8ihme1kb2kngna64f721q@.4ax.com...
> On Wed, 27 Oct 2004 16:03:02 -0700, GYK
> <GYK@.discussions.microsoft.com> wrote:
>>Which SQL profiler template have you selected? One of the template
>>(standard)
>>displays TextData field.
> I am capturing/displaying the textdata field, but it's empty on the
> showplan lines, and in the statement lines I still see just the
> statements. I used the SQLProfilerStandard template, and one of my
> own, didn't seem to matter. I added all the TSQL events, that didn't
> help either.
> J.
>
>>Thanks
>>GYK
>>"JXStern" wrote:
>> I turn on profiler Performance/Execution Plan, and expect to see the
>> plan in the textdata field - but it's not there.
>> Is there some event class or other field or something that must also
>> be included that I've missed?
>> Thanks.
>> Josh
>>
>|||On Wed, 27 Oct 2004 16:27:33 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>You have to capture the Binary Data to see the Showplan output.
Wait a minute. I changed the template to capture BinaryData field,
and sure enough, now I got the Showplan tree - in the TextData field!
So I removed the BinaryData field, and now I *still* get the Showplan
tree in the TextData field. Even after I exit and restart Profiler!
Is this some weird bug in SQL2K, that you have to first ask for the
BinaryData, then you can stop asking for it, to get the Showplan tree?
Weird.
But it worked, so thanks!
Josh|||That IS weird. When I remove the binary data column I don't get the showplan
anymore.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:ebf0o0pldmaluufjgic4lstkb6ovectqob@.4ax.com...
> On Wed, 27 Oct 2004 16:27:33 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
>>You have to capture the Binary Data to see the Showplan output.
> Wait a minute. I changed the template to capture BinaryData field,
> and sure enough, now I got the Showplan tree - in the TextData field!
> So I removed the BinaryData field, and now I *still* get the Showplan
> tree in the TextData field. Even after I exit and restart Profiler!
> Is this some weird bug in SQL2K, that you have to first ask for the
> BinaryData, then you can stop asking for it, to get the Showplan tree?
> Weird.
> But it worked, so thanks!
> Josh
>|||What event are you capturing... showplan or execution plan?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:ebf0o0pldmaluufjgic4lstkb6ovectqob@.4ax.com...
> On Wed, 27 Oct 2004 16:27:33 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
>>You have to capture the Binary Data to see the Showplan output.
> Wait a minute. I changed the template to capture BinaryData field,
> and sure enough, now I got the Showplan tree - in the TextData field!
> So I removed the BinaryData field, and now I *still* get the Showplan
> tree in the TextData field. Even after I exit and restart Profiler!
> Is this some weird bug in SQL2K, that you have to first ask for the
> BinaryData, then you can stop asking for it, to get the Showplan tree?
> Weird.
> But it worked, so thanks!
> Josh
>|||On Wed, 27 Oct 2004 17:58:04 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>What event are you capturing... showplan or execution plan?
Execution plan.
J.|||On Wed, 27 Oct 2004 17:48:58 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>That IS weird. When I remove the binary data column I don't get the showplan
>anymore.
But when you get it, is it in the binary or text field?|||JXStern wrote:
> On Wed, 27 Oct 2004 17:58:04 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
>> What event are you capturing... showplan or execution plan?
> Execution plan.
> J.
Execution Plan only requires TextData. Show Plan, if I'm not mistaken,
requires BinaryData.
--
David Gugick
Imceda Software
www.imceda.com|||I just found this... not that it gives a whole lot more info, but at least
it's documented:
http://support.microsoft.com/default.aspx?scid=kb;en-us;272439
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OCy3cfKvEHA.1988@.TK2MSFTNGP12.phx.gbl...
> JXStern wrote:
>> On Wed, 27 Oct 2004 17:58:04 -0700, "Kalen Delaney"
>> <replies@.public_newsgroups.com> wrote:
>> What event are you capturing... showplan or execution plan?
>> Execution plan.
>> J.
> Execution Plan only requires TextData. Show Plan, if I'm not mistaken,
> requires BinaryData.
> --
> David Gugick
> Imceda Software
> www.imceda.com|||On Thu, 28 Oct 2004 22:46:23 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>I just found this... not that it gives a whole lot more info, but at least
>it's documented:
>http://support.microsoft.com/default.aspx?scid=kb;en-us;272439
Kinky (eg, a bug) but it doesn't explain the even weirder case I saw.
J.|||But we just have your word for it, right.
Have you been able to duplicate it?
;-)
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:vjs7o0lvo1o2799j6033qlc1ibk6ab9uo9@.4ax.com...
> On Thu, 28 Oct 2004 22:46:23 -0700, "Kalen Delaney"
> <replies@.public_newsgroups.com> wrote:
>>I just found this... not that it gives a whole lot more info, but at least
>>it's documented:
>>http://support.microsoft.com/default.aspx?scid=kb;en-us;272439
> Kinky (eg, a bug) but it doesn't explain the even weirder case I saw.
> J.
>|||On Sat, 30 Oct 2004 15:19:57 -0700, "Kalen Delaney"
<replies@.public_newsgroups.com> wrote:
>But we just have your word for it, right.
>Have you been able to duplicate it?
>;-)
Now that you ask, no.
I just tried it, and on a clean startup, this time I *did* get the
execution plan - *without* also getting the binary!
Looks random. Isn't that special?
:)
J.

Profiler ....duration

In SQL Server 2000, "Duration" in profiler (which is in milliseconds) taken by the event; does it include time for the network transfer of the results to the client as well ; or its just the duration taken by SQL Server to complete the SQL Statement.All the measurements are serverside only, so no network time. If you want to see the network time then run the query in query analyser but before you start right click and select client side statistics.|||

thanks for the info.

I have a 3rd party application & the queries are generated from the application.

So I wanted to see the total duration. Queries are very dynamic, so running from Query Analyzer may not yield same result w.r.t. time/ network load when the app runs/ etc etc ... So i am trapping it in profiler.

|||Then there is no easy way to get this with the built in tools.

Process ID 65 attempting to unlock unowned resource

Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
I am getting the above error in the event log for my website.
Can someone help me and tell me what this means?
thansk in Advance. Kim
Hi
See if this applies:
http://support.microsoft.com/?kbid=814654
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net. ..
> Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> I am getting the above error in the event log for my website.
> Can someone help me and tell me what this means?
> thansk in Advance. Kim
>
|||Hi,
It looks to be the exact problem - except we are running with service pak 4
here's the version info
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer
Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
> Hi
> See if this applies:
> http://support.microsoft.com/?kbid=814654
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net. ..
>
|||Hi
You are running Windows SP4, but SQL Server SP3 (8.00.760)
The problem was fixed in build 765 which was after SP3.
You can do one of the following:
Download the Security Hotfix Rollup that will take you build to 818
(http://www.microsoft.com/downloads/d...displaylang=en)
Download build 878,
http://support.microsoft.com/default...b;en-us;838166
Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
your server is not using AWE or PAE as there is a known issue with it and
SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
http://msmvps.com/epprecht/archive/2.../14/46940.aspx
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net.. .
> Hi,
> It looks to be the exact problem - except we are running with service pak
> 4
> here's the version info
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer
> Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
>
|||Hi,
Thanks for your help.
I will pass this on to the guy who will do the updates.
Kim
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eoxzWthWFHA.2976@.TK2MSFTNGP10.phx.gbl...
> Hi
> You are running Windows SP4, but SQL Server SP3 (8.00.760)
> The problem was fixed in build 765 which was after SP3.
> You can do one of the following:
> Download the Security Hotfix Rollup that will take you build to 818
>
(http://www.microsoft.com/downloads/d...ae9d-bd44-40c5
-add3-b8c99618e68d&displaylang=en)[vbcol=seagreen]
> Download build 878,
> http://support.microsoft.com/default...b;en-us;838166
> Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
> your server is not using AWE or PAE as there is a known issue with it and
> SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
> http://msmvps.com/epprecht/archive/2.../14/46940.aspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net.. .
pak
>

Process ID 65 attempting to unlock unowned resource

Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
I am getting the above error in the event log for my website.
Can someone help me and tell me what this means?
thansk in Advance. KimHi
See if this applies:
http://support.microsoft.com/?kbid=814654
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
> Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> I am getting the above error in the event log for my website.
> Can someone help me and tell me what this means?
> thansk in Advance. Kim
>|||Hi,
It looks to be the exact problem - except we are running with service pak 4
here's the version info
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer
Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
> Hi
> See if this applies:
> http://support.microsoft.com/?kbid=814654
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
> > Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> >
> > I am getting the above error in the event log for my website.
> > Can someone help me and tell me what this means?
> >
> > thansk in Advance. Kim
> >
> >
>|||Hi
You are running Windows SP4, but SQL Server SP3 (8.00.760)
The problem was fixed in build 765 which was after SP3.
You can do one of the following:
Download the Security Hotfix Rollup that will take you build to 818
(http://www.microsoft.com/downloads/details.aspx?FamilyID=9814ae9d-bd44-40c5-add3-b8c99618e68d&displaylang=en)
Download build 878,
http://support.microsoft.com/default.aspx?scid=kb;en-us;838166
Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
your server is not using AWE or PAE as there is a known issue with it and
SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
http://msmvps.com/epprecht/archive/2005/05/14/46940.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net...
> Hi,
> It looks to be the exact problem - except we are running with service pak
> 4
> here's the version info
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer
> Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
>> Hi
>> See if this applies:
>> http://support.microsoft.com/?kbid=814654
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Kim" <kim@.xxx.com> wrote in message
>> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
>> > Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
>> >
>> > I am getting the above error in the event log for my website.
>> > Can someone help me and tell me what this means?
>> >
>> > thansk in Advance. Kim
>> >
>> >
>>
>|||Hi,
Thanks for your help.
I will pass this on to the guy who will do the updates.
Kim
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eoxzWthWFHA.2976@.TK2MSFTNGP10.phx.gbl...
> Hi
> You are running Windows SP4, but SQL Server SP3 (8.00.760)
> The problem was fixed in build 765 which was after SP3.
> You can do one of the following:
> Download the Security Hotfix Rollup that will take you build to 818
>
(http://www.microsoft.com/downloads/details.aspx?FamilyID=9814ae9d-bd44-40c5
-add3-b8c99618e68d&displaylang=en)
> Download build 878,
> http://support.microsoft.com/default.aspx?scid=kb;en-us;838166
> Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
> your server is not using AWE or PAE as there is a known issue with it and
> SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
> http://msmvps.com/epprecht/archive/2005/05/14/46940.aspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net...
> > Hi,
> > It looks to be the exact problem - except we are running with service
pak
> > 4
> > here's the version info
> >
> > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation Developer
> > Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> >
> >
> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> > news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
> >> Hi
> >>
> >> See if this applies:
> >>
> >> http://support.microsoft.com/?kbid=814654
> >>
> >> Regards
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> IM: mike@.epprecht.net
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >> "Kim" <kim@.xxx.com> wrote in message
> >> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
> >> > Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> >> >
> >> > I am getting the above error in the event log for my website.
> >> > Can someone help me and tell me what this means?
> >> >
> >> > thansk in Advance. Kim
> >> >
> >> >
> >>
> >>
> >
> >
>

Process ID 65 attempting to unlock unowned resource

Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
I am getting the above error in the event log for my website.
Can someone help me and tell me what this means?
thansk in Advance. KimHi
See if this applies:
http://support.microsoft.com/?kbid=814654
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
> Process ID 65 attempting to unlock unowned resource PAG: 7:1:166448.
> I am getting the above error in the event log for my website.
> Can someone help me and tell me what this means?
> thansk in Advance. Kim
>|||Hi,
It looks to be the exact problem - except we are running with service pak 4
here's the version info
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer
Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
> Hi
> See if this applies:
> http://support.microsoft.com/?kbid=814654
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:ZW_he.25101$0i3.23178@.bignews3.bellsouth.net...
>|||Hi
You are running Windows SP4, but SQL Server SP3 (8.00.760)
The problem was fixed in build 765 which was after SP3.
You can do one of the following:
Download the Security Hotfix Rollup that will take you build to 818
(http://www.microsoft.com/downloads/...&displaylang=en)
Download build 878,
http://support.microsoft.com/defaul...kb;en-us;838166
Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
your server is not using AWE or PAE as there is a known issue with it and
SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
http://msmvps.com/epprecht/archive/...5/14/46940.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kim" <kim@.xxx.com> wrote in message
news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net...
> Hi,
> It looks to be the exact problem - except we are running with service pak
> 4
> here's the version info
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer
> Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:%23px3ddhWFHA.2960@.TK2MSFTNGP15.phx.gbl...
>|||Hi,
Thanks for your help.
I will pass this on to the guy who will do the updates.
Kim
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:eoxzWthWFHA.2976@.TK2MSFTNGP10.phx.gbl...
> Hi
> You are running Windows SP4, but SQL Server SP3 (8.00.760)
> The problem was fixed in build 765 which was after SP3.
> You can do one of the following:
> Download the Security Hotfix Rollup that will take you build to 818
>
(http://www.microsoft.com/downloads/...4ae9d-bd44-40c5
-add3-b8c99618e68d&displaylang=en)
> Download build 878,
> http://support.microsoft.com/defaul...kb;en-us;838166
> Or apply SP4 for SQL Server. If you are going to apply SP4, make sure that
> your server is not using AWE or PAE as there is a known issue with it and
> SP4. http://www.microsoft.com/sql/downloads/2000/sp4.asp and
> http://msmvps.com/epprecht/archive/...5/14/46940.aspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kim" <kim@.xxx.com> wrote in message
> news:LY0ie.14211$7A2.2550@.bignews6.bellsouth.net...
pak[vbcol=seagreen]
>