Customer's server, so I can't explain or change the jobs...
At 3:00 am every day, a job runs that calls DBCC PINTABLE on three tables
At 5:00 PM, another job runs that calls DBCC UNPINTABLE on those same three
tables
Both report to complete successfully, but the UNPINTABLE job causes an
access violation and creates a mini-dump file.
SQL Server 2000, sp4 plus the AWE hotfix (.2040), Windows 2K3, sp1,
single-instance 2 node cluster
Nothing on MS Site about UNPINTABLE causing AVs...
All input appreciated :)
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.comContact Product Support...
--
Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:e7tDJ6iEHHA.4404@.TK2MSFTNGP06.phx.gbl...
> Customer's server, so I can't explain or change the jobs...
> At 3:00 am every day, a job runs that calls DBCC PINTABLE on three tables
> At 5:00 PM, another job runs that calls DBCC UNPINTABLE on those same
> three tables
> Both report to complete successfully, but the UNPINTABLE job causes an
> access violation and creates a mini-dump file.
> SQL Server 2000, sp4 plus the AWE hotfix (.2040), Windows 2K3, sp1,
> single-instance 2 node cluster
> Nothing on MS Site about UNPINTABLE causing AVs...
> All input appreciated :)
>
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> Real-world stuff I run across with SQL Server:
> http://kevin3nf.blogspot.com
>
>|||Hi Paul,
I have asked my customer if he wants to pay for that call. Unless you can
hit //bugcheck for me and see if this a known but "not going to fix"
bug...:)
I've also asked him why on earth he is still using PINTABLE and UNPINTABLE.
I thought that went out of style with 6.5
Thanks for the response!
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Paul S Randal [MS]" <prandal@.online.microsoft.com> wrote in message
news:OKsXrnnEHHA.3836@.TK2MSFTNGP02.phx.gbl...
> Contact Product Support...
> --
> Paul Randal
> Lead Program Manager, Microsoft SQL Server Storage Engine
> http://blogs.msdn.com/sqlserverstorageengine/default.aspx
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:e7tDJ6iEHHA.4404@.TK2MSFTNGP06.phx.gbl...
>> Customer's server, so I can't explain or change the jobs...
>> At 3:00 am every day, a job runs that calls DBCC PINTABLE on three tables
>> At 5:00 PM, another job runs that calls DBCC UNPINTABLE on those same
>> three tables
>> Both report to complete successfully, but the UNPINTABLE job causes an
>> access violation and creates a mini-dump file.
>> SQL Server 2000, sp4 plus the AWE hotfix (.2040), Windows 2K3, sp1,
>> single-instance 2 node cluster
>> Nothing on MS Site about UNPINTABLE causing AVs...
>> All input appreciated :)
>>
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> Real-world stuff I run across with SQL Server:
>> http://kevin3nf.blogspot.com
>>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment