Does anybody know about the _hypmv_ indexed views?

[melontek]

I'm hoping that someone can help me. We had issues on our production database. We found two indexed views, "_hypmv_0" and "_hypmv_1" on a table that we were trying to insert some logging information into. Our app's connection did not have ARITHABORT set correctly so we couldn't insert anything into our table.

We dropped the views and everything returned to normal. However, I want to know where they came from. Does anybody know? I've tried Google and Microsoft with no luck at all.

Thanks.

 

[NoCoolHandle]

Was this a packaged database or one your people developed?


Rob

 

[melontek]

It was a custom job written by a consulting firm. They've been out of the picture for quite awhile now and this view was created yesterday afternoon.

 

[melontek]

Is it possible that these views came from .NET? Found out a business user created a home-grown VB.NET app that he was using to query the table.

 

[rsai]

Hi

we just had 9/10 indexed views appear on the system called _hypmv_nn which managed to lock critical files in our overnight. did you get any further with your investigations...I wonder given the naming if they were generated by a Hyperion/Brio application?

 

[melontek]

I haven't gone too far. I've had people suggest that it's the Index Tuning Wizard (?) that created those views.

It's possibly related to a VB.NET app a business user created and didn't tell anyone about. He had a data grid on the app that may have created the views.

The .NET framework is extensive so the current theory is that the views were created specifically for an instance of the application that was running. They were either left there for future use or just never cleaned up. Note that I said "theory".

Sorry, not much help. If I ever do find out exactly what caused them, I will be sure to post.

Thanks.

 

[GPuller]

These views are created by the index tuning wizzard in SQL Query Analyzer.