Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

main problem for disk io issues in sql serer applications

Posted on 2011-09-19
4
Medium Priority
?
511 Views
Last Modified: 2012-05-12
our network engineer says that in sql server the main reason why Disk always has IO issues (disk latency) is because the programmers write lousy code (stored procs and functions) and it causes lot of locks..

would you agree with this statement? is it balanced from your experience..
0
Comment
Question by:25112
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Lowfatspread earned 2000 total points
ID: 36564466
poor coding will always be a feature / source of performance issues...

to my mind the more usual reasons are poor initial database design, poor physical database design/implementation,
lack of a performance tuning stage to the development process, lack of ongoing DBA management of the databases...
0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 36564473
... I assume that you use a peer review processing in code development?
    and that a DBA sql specialist is involved?
0
 
LVL 5

Author Comment

by:25112
ID: 36567747
thanks for the confirmation. it was helpful...
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully t…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question