Hi
My SQL server crushed and I found in event view the following information.

SQL Server has encountered 3 occurrence(s) of cachestore flush for the 'SQL
Plans' cachestore (part of plan cache) due to some database maintenance or
reconfigure operations.

or

SQL Server has encountered 3 occurrence(s) of cachestore flush for the
'Bound Trees' cachestore (part of plan cache) due to some database
maintenance or reconfigure operations.

or
SQL Server has encountered 3 occurrence(s) of cachestore flush for the
'Object Plans' cachestore (part of plan cache) due to some database
maintenance or reconfigure operations.

Hi
Someone runs DBCC FREESYSTEMCACHE?






"Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
news:709BD78A-5478-493E-99B2-4DFA7298BC44@microsoft.com...
> Hi
> My SQL server crushed and I found in event view the following information.
>
> SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> 'SQL
> Plans' cachestore (part of plan cache) due to some database maintenance or
> reconfigure operations.
>
> or
>
> SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> 'Bound Trees' cachestore (part of plan cache) due to some database
> maintenance or reconfigure operations.
>
> or
> SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> 'Object Plans' cachestore (part of plan cache) due to some database
> maintenance or reconfigure operations.
>
>

No,
I backup database A in SQL2000 and restore it in SQL2005.
But when I run application report in SQL2005,it crushed .
It shows the network connection error.
And I found in the eventviews the three logs.


"Uri Dimant" wrote:

> Hi
> Someone runs DBCC FREESYSTEMCACHE?
>
>
>
>
>
>
> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
> news:709BD78A-5478-493E-99B2-4DFA7298BC44@microsoft.com...
> > Hi
> > My SQL server crushed and I found in event view the following information.
> >
> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> > 'SQL
> > Plans' cachestore (part of plan cache) due to some database maintenance or
> > reconfigure operations.
> >
> > or
> >
> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> > 'Bound Trees' cachestore (part of plan cache) due to some database
> > maintenance or reconfigure operations.
> >
> > or
> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> > 'Object Plans' cachestore (part of plan cache) due to some database
> > maintenance or reconfigure operations.
> >
> >
>
>
>

No,
I backup database A in SQL2000 and restore it in SQL2005.
But when I run application report in SQL2005,it crushed .
It shows the network connection error.
And I found in the eventviews the three logs.


"Uri Dimant" wrote:

> Hi
> Someone runs DBCC FREESYSTEMCACHE?
>
>
>
>
>
>
> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
> news:709BD78A-5478-493E-99B2-4DFA7298BC44@microsoft.com...
> > Hi
> > My SQL server crushed and I found in event view the following information.
> >
> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> > 'SQL
> > Plans' cachestore (part of plan cache) due to some database maintenance or
> > reconfigure operations.
> >
> > or
> >
> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> > 'Bound Trees' cachestore (part of plan cache) due to some database
> > maintenance or reconfigure operations.
> >
> > or
> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> > 'Object Plans' cachestore (part of plan cache) due to some database
> > maintenance or reconfigure operations.
> >
> >
>
>
>

Hi
Can you provide more info? What does report do? Have you coonected to SQL
Server 2005 without problem?



"Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
news8FC62FD-0EC8-415D-8A3B-8B7FBC8FE8A1@microsoft.com...
> No,
> I backup database A in SQL2000 and restore it in SQL2005.
> But when I run application report in SQL2005,it crushed .
> It shows the network connection error.
> And I found in the eventviews the three logs.
>
>
> "Uri Dimant" wrote:
>
>> Hi
>> Someone runs DBCC FREESYSTEMCACHE?
>>
>>
>>
>>
>>
>>
>> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
>> news:709BD78A-5478-493E-99B2-4DFA7298BC44@microsoft.com...
>> > Hi
>> > My SQL server crushed and I found in event view the following
>> > information.
>> >
>> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
>> > 'SQL
>> > Plans' cachestore (part of plan cache) due to some database maintenance
>> > or
>> > reconfigure operations.
>> >
>> > or
>> >
>> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
>> > 'Bound Trees' cachestore (part of plan cache) due to some database
>> > maintenance or reconfigure operations.
>> >
>> > or
>> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
>> > 'Object Plans' cachestore (part of plan cache) due to some database
>> > maintenance or reconfigure operations.
>> >
>> >
>>
>>
>>

The report is a third part application .
there is no problem to connect SQL 2005.

"Uri Dimant" wrote:

> Hi
> Can you provide more info? What does report do? Have you coonected to SQL
> Server 2005 without problem?
>
>
>
> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
> news8FC62FD-0EC8-415D-8A3B-8B7FBC8FE8A1@microsoft.com...
> > No,
> > I backup database A in SQL2000 and restore it in SQL2005.
> > But when I run application report in SQL2005,it crushed .
> > It shows the network connection error.
> > And I found in the eventviews the three logs.
> >
> >
> > "Uri Dimant" wrote:
> >
> >> Hi
> >> Someone runs DBCC FREESYSTEMCACHE?
> >>
> >>
> >>
> >>
> >>
> >>
> >> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
> >> news:709BD78A-5478-493E-99B2-4DFA7298BC44@microsoft.com...
> >> > Hi
> >> > My SQL server crushed and I found in event view the following
> >> > information.
> >> >
> >> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> >> > 'SQL
> >> > Plans' cachestore (part of plan cache) due to some database maintenance
> >> > or
> >> > reconfigure operations.
> >> >
> >> > or
> >> >
> >> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> >> > 'Bound Trees' cachestore (part of plan cache) due to some database
> >> > maintenance or reconfigure operations.
> >> >
> >> > or
> >> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> >> > 'Object Plans' cachestore (part of plan cache) due to some database
> >> > maintenance or reconfigure operations.
> >> >
> >> >
> >>
> >>
> >>
>
>
>

How big is your SQL Server memory? Is it 64 bit?




"Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
news:34155CB7-5315-4949-8EAA-5E60C41CE432@microsoft.com...
> The report is a third part application .
> there is no problem to connect SQL 2005.
>
> "Uri Dimant" wrote:
>
>> Hi
>> Can you provide more info? What does report do? Have you coonected to SQL
>> Server 2005 without problem?
>>
>>
>>
>> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
>> news8FC62FD-0EC8-415D-8A3B-8B7FBC8FE8A1@microsoft.com...
>> > No,
>> > I backup database A in SQL2000 and restore it in SQL2005.
>> > But when I run application report in SQL2005,it crushed .
>> > It shows the network connection error.
>> > And I found in the eventviews the three logs.
>> >
>> >
>> > "Uri Dimant" wrote:
>> >
>> >> Hi
>> >> Someone runs DBCC FREESYSTEMCACHE?
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
>> >> news:709BD78A-5478-493E-99B2-4DFA7298BC44@microsoft.com...
>> >> > Hi
>> >> > My SQL server crushed and I found in event view the following
>> >> > information.
>> >> >
>> >> > SQL Server has encountered 3 occurrence(s) of cachestore flush for
>> >> > the
>> >> > 'SQL
>> >> > Plans' cachestore (part of plan cache) due to some database
>> >> > maintenance
>> >> > or
>> >> > reconfigure operations.
>> >> >
>> >> > or
>> >> >
>> >> > SQL Server has encountered 3 occurrence(s) of cachestore flush for
>> >> > the
>> >> > 'Bound Trees' cachestore (part of plan cache) due to some database
>> >> > maintenance or reconfigure operations.
>> >> >
>> >> > or
>> >> > SQL Server has encountered 3 occurrence(s) of cachestore flush for
>> >> > the
>> >> > 'Object Plans' cachestore (part of plan cache) due to some database
>> >> > maintenance or reconfigure operations.
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

1G.32bit.

"Uri Dimant" wrote:

> How big is your SQL Server memory? Is it 64 bit?
>
>
>
>
> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
> news:34155CB7-5315-4949-8EAA-5E60C41CE432@microsoft.com...
> > The report is a third part application .
> > there is no problem to connect SQL 2005.
> >
> > "Uri Dimant" wrote:
> >
> >> Hi
> >> Can you provide more info? What does report do? Have you coonected to SQL
> >> Server 2005 without problem?
> >>
> >>
> >>
> >> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
> >> news8FC62FD-0EC8-415D-8A3B-8B7FBC8FE8A1@microsoft.com...
> >> > No,
> >> > I backup database A in SQL2000 and restore it in SQL2005.
> >> > But when I run application report in SQL2005,it crushed .
> >> > It shows the network connection error.
> >> > And I found in the eventviews the three logs.
> >> >
> >> >
> >> > "Uri Dimant" wrote:
> >> >
> >> >> Hi
> >> >> Someone runs DBCC FREESYSTEMCACHE?
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
> >> >> news:709BD78A-5478-493E-99B2-4DFA7298BC44@microsoft.com...
> >> >> > Hi
> >> >> > My SQL server crushed and I found in event view the following
> >> >> > information.
> >> >> >
> >> >> > SQL Server has encountered 3 occurrence(s) of cachestore flush for
> >> >> > the
> >> >> > 'SQL
> >> >> > Plans' cachestore (part of plan cache) due to some database
> >> >> > maintenance
> >> >> > or
> >> >> > reconfigure operations.
> >> >> >
> >> >> > or
> >> >> >
> >> >> > SQL Server has encountered 3 occurrence(s) of cachestore flush for
> >> >> > the
> >> >> > 'Bound Trees' cachestore (part of plan cache) due to some database
> >> >> > maintenance or reconfigure operations.
> >> >> >
> >> >> > or
> >> >> > SQL Server has encountered 3 occurrence(s) of cachestore flush for
> >> >> > the
> >> >> > 'Object Plans' cachestore (part of plan cache) due to some database
> >> >> > maintenance or reconfigure operations.
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

I am not sure the crash was due to the messages. They can appear for various
reasons and are not necessarily a problem. I would look to see what other
events may be in the logs. Have a look here:

http://support.microsoft.com/default.aspx/kb/917828

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
news:709BD78A-5478-493E-99B2-4DFA7298BC44@microsoft.com...
> Hi
> My SQL server crushed and I found in event view the following information.
>
> SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> 'SQL
> Plans' cachestore (part of plan cache) due to some database maintenance or
> reconfigure operations.
>
> or
>
> SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> 'Bound Trees' cachestore (part of plan cache) due to some database
> maintenance or reconfigure operations.
>
> or
> SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> 'Object Plans' cachestore (part of plan cache) due to some database
> maintenance or reconfigure operations.
>
>

I backup a database in SQL2000 and restore it to SQL2005.
the application runs correctly in SQL 2000, but it runs uncorrectly in SQL
2005.
when the application hangs , the cache flush information is shown in event
views.


"Andrew J. Kelly" wrote:

> I am not sure the crash was due to the messages. They can appear for various
> reasons and are not necessarily a problem. I would look to see what other
> events may be in the logs. Have a look here:
>
> http://support.microsoft.com/default.aspx/kb/917828
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
>
> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
> news:709BD78A-5478-493E-99B2-4DFA7298BC44@microsoft.com...
> > Hi
> > My SQL server crushed and I found in event view the following information.
> >
> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> > 'SQL
> > Plans' cachestore (part of plan cache) due to some database maintenance or
> > reconfigure operations.
> >
> > or
> >
> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> > 'Bound Trees' cachestore (part of plan cache) due to some database
> > maintenance or reconfigure operations.
> >
> > or
> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> > 'Object Plans' cachestore (part of plan cache) due to some database
> > maintenance or reconfigure operations.
> >
> >
>
>

There are lots of things that can be causing this. Is the 2005 instance on
another server or the same one? How much memory do you have devoted to the
2005 instance? Did you run sp_updatestats on the 2005 db after you restored
it?

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
news:E0D8F3CE-0B3D-46FE-9ADB-0DD73DFE5958@microsoft.com...
>I backup a database in SQL2000 and restore it to SQL2005.
> the application runs correctly in SQL 2000, but it runs uncorrectly in SQL
> 2005.
> when the application hangs , the cache flush information is shown in event
> views.
>
>
> "Andrew J. Kelly" wrote:
>
>> I am not sure the crash was due to the messages. They can appear for
>> various
>> reasons and are not necessarily a problem. I would look to see what other
>> events may be in the logs. Have a look here:
>>
>> http://support.microsoft.com/default.aspx/kb/917828
>>
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>>
>> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
>> news:709BD78A-5478-493E-99B2-4DFA7298BC44@microsoft.com...
>> > Hi
>> > My SQL server crushed and I found in event view the following
>> > information.
>> >
>> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
>> > 'SQL
>> > Plans' cachestore (part of plan cache) due to some database maintenance
>> > or
>> > reconfigure operations.
>> >
>> > or
>> >
>> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
>> > 'Bound Trees' cachestore (part of plan cache) due to some database
>> > maintenance or reconfigure operations.
>> >
>> > or
>> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
>> > 'Object Plans' cachestore (part of plan cache) due to some database
>> > maintenance or reconfigure operations.
>> >
>> >
>>
>>

The 2005 instance is on another server.and the SQL server is 1G ram.
I haven't run sp_updatestats .
Due to urgent situation, I have restore the database to another SQL 2000
instance.
The application runs correctly now.

"Andrew J. Kelly" wrote:

> There are lots of things that can be causing this. Is the 2005 instance on
> another server or the same one? How much memory do you have devoted to the
> 2005 instance? Did you run sp_updatestats on the 2005 db after you restored
> it?
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
>
> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
> news:E0D8F3CE-0B3D-46FE-9ADB-0DD73DFE5958@microsoft.com...
> >I backup a database in SQL2000 and restore it to SQL2005.
> > the application runs correctly in SQL 2000, but it runs uncorrectly in SQL
> > 2005.
> > when the application hangs , the cache flush information is shown in event
> > views.
> >
> >
> > "Andrew J. Kelly" wrote:
> >
> >> I am not sure the crash was due to the messages. They can appear for
> >> various
> >> reasons and are not necessarily a problem. I would look to see what other
> >> events may be in the logs. Have a look here:
> >>
> >> http://support.microsoft.com/default.aspx/kb/917828
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >> Solid Quality Mentors
> >>
> >>
> >> "Haoqiang" <Haoqiang@discussions.microsoft.com> wrote in message
> >> news:709BD78A-5478-493E-99B2-4DFA7298BC44@microsoft.com...
> >> > Hi
> >> > My SQL server crushed and I found in event view the following
> >> > information.
> >> >
> >> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> >> > 'SQL
> >> > Plans' cachestore (part of plan cache) due to some database maintenance
> >> > or
> >> > reconfigure operations.
> >> >
> >> > or
> >> >
> >> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> >> > 'Bound Trees' cachestore (part of plan cache) due to some database
> >> > maintenance or reconfigure operations.
> >> >
> >> > or
> >> > SQL Server has encountered 3 occurrence(s) of cachestore flush for the
> >> > 'Object Plans' cachestore (part of plan cache) due to some database
> >> > maintenance or reconfigure operations.
> >> >
> >> >
> >>
> >>
>
>