Read more
- Community Home
- >
- Servers and Operating Systems
- >
- ProLiant
- >
- Server Management - Systems Insight Manager
- >
- DB disk IO problems - deathstar query
-
-
Categories
- Topics
- Hybrid IT with Cloud
- Mobile & IoT
- IT for Data & Analytics
- Transformation
- Strategy and Technology
- Products
- Cloud
- Integrated Systems
- Networking
- Servers and Operating Systems
- Services
- Storage
- Company
- Events
- Partner Solutions and Certifications
- Welcome
- Welcome
- Announcements
- Tips and Tricks
- Feedback
-
Blogs
- Alliances
- Around the Storage Block
- Behind the scenes @ Labs
- Converged Data Center Infrastructure
- Digital Transformation
- Grounded in the Cloud
- HPE Careers
- HPE Storage Tech Insiders
- Infrastructure Insights
- Inspiring Progress
- Internet of Things (IoT)
- My Learning Certification
- Networking
- OEM Solutions
- Servers: The Right Compute
- Telecom IQ
- Transforming IT
-
Quick Links
- Community
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Contact
- Email us
- Tell us what you think
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Enterprise.nxt
- Marketplace
- Aruba Airheads Community
-
Categories
-
Forums
-
Blogs
-
InformationEnglish
DB disk IO problems - deathstar query
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-15-2014 06:33 AM
04-15-2014 06:33 AM
DB disk IO problems - deathstar query
DB disk IO problems - deathstar query
Hi Forum,
Why is this query at the top of the leaderboard over most resource consuming tasks in my DB-server?
SELECT trapItems.trap_id, RTRIM(trap_name), enabled_flag, trapItems.sev_vb FROM trapItems,trapItemsEx WHERE trapItems.trap_id = trapItemsEx.trap_id AND trap_generic_id = @P0
It is since this thursday continuously generating 60-80MB/s in disk access, why o why is this happening?
Any ideas of how to kill this deathstar?
Best Regards,
Johannes
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-15-2014 11:50 PM
04-15-2014 11:50 PM
Re: DB disk IO problems - deathstar query
Re: DB disk IO problems - deathstar query
Hi,
as far as i can see, database file I/O more then trippled since last thursday. We have not added the tripple amount of objects and actually done no additional configurations at all.
I can see that the query executes is as intended, but what is strange is the disk I/O. Is there any way to make this deathstar query happen less often? The SIM DB is now our top contender on this particular storage array which is odd since it more or less does nothing except for monitoring hardware alerts.
Best Regards,
Johannes
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-16-2014 04:28 AM
04-16-2014 04:28 AM
Re: DB disk IO problems - deathstar query
Re: DB disk IO problems - deathstar query
Aight,
restarting any and all SIM services did the trick and IO settled, as long as the services were turned off of course, as soon as SIM loaded its ray gun DB file I/O got aggressive again.
Actually restarting the SQL-service did the trick for definite. I have looked through at what could have got stuck but found absolutely nothing.
BR,
Johannes
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-24-2014 12:09 AM
06-24-2014 12:09 AM
Re: DB disk IO problems - deathstar query
Re: DB disk IO problems - deathstar query
This obnixious behaviour keeps coming back over and over again, this is really really bad for my SAN.
Any ideas?
BR,
johannes
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
06-24-2014 12:54 AM
06-24-2014 12:54 AM
Re: DB disk IO problems - deathstar query
Re: DB disk IO problems - deathstar query
Hello,
Did you set the Database logging to simple ? If it is set to Full the logfiles tend to explode. An other thing could be that you get a lot of events. The combination is lethal.
I've seen the SIM server using the full 100Mb link to the SQL server. You could also do a database check in the comamdnline on the SIM server type MXCONFIGREPO -c. for a database check. If you see corruption use the -f option to fix your database errors.
Kind regards,
Andrew
Andrew
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2018 Hewlett Packard Enterprise Development LP