- Community Home
- >
- Storage
- >
- Entry Storage Systems
- >
- MSA Storage
- >
- Re: MSA2000 SQL Performance
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- 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
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2008 05:22 AM
тАО10-15-2008 05:22 AM
MSA2000 SQL Performance
the query returns some values about every 30 minutes and sometimes will just stop doing this. There are no errors on the server or on the MSA. if you watch task manager for the iSCSI NIC you can see traffic all of a sudden stop. it's pretty sporadic and sometimes will take 14 hours of this query running before having an issue.
Anyone having similar issues with the MSA?
Anyone having similar issues with SQL on an iSCSI SAN?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2008 08:33 AM
тАО10-15-2008 08:33 AM
Re: MSA2000 SQL Performance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2008 08:36 AM
тАО10-15-2008 08:36 AM
Re: MSA2000 SQL Performance
Sql logs also don't show anything which is very strange.
i just don't know where else to look.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2008 08:41 AM
тАО10-15-2008 08:41 AM
Re: MSA2000 SQL Performance
Can you access the file system after the I/O has stopped?
I don't really have an idea, sorry. How about running an IOMETER task (should be set up to only do a little I/O) against the same disk at the same time to see if the MSA stalls or SQL server?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2008 10:14 AM
тАО10-15-2008 10:14 AM
Re: MSA2000 SQL Performance
IOMeter might be an option but as far as i can tell it won't really give me data at specific times. it just gives me averages. I could be wrong.
if the query runs ok for 10 hours the averages don't help too much.
Perfmon didn't show anything strange though.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2008 04:55 AM
тАО10-17-2008 04:55 AM
Re: MSA2000 SQL Performance
We were running iSCSI over our Broadcom NetExtreme II GigE adapter that was built into the Dell Poweredge 2950.
We bought a new Intel card and ran iSCSI through that instead and have had no issues in 2 days.
i saw on another forum that someone else was having san issues with this adapter as well.
hope this helps someone else in the future.