?
Solved

Performance

Posted on 2011-03-14
8
Medium Priority
?
479 Views
Last Modified: 2012-06-21
What kind of issues can cause performance problems in the database tier of a web app driven by a MS-SQL database?

Are there any tools (ideally free) that can identify the root cause of such performance issues, if yes can you please detail?

Out of interest if a web app or maybe even an internal intranet app goes sluggish is it typically a result of an issue in the db tier, or elsewhere?
0
Comment
Question by:pma111
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 500 total points
ID: 35128466
Are you performing regular maintenance on the database?  Reindexing, updating of statistics, backups?
0
 
LVL 3

Author Comment

by:pma111
ID: 35128533
Not being a DBA myself, can you let me know how...

reindexing
updating of statistics
backups

...affect performance.... and how someone could check if it is or is not being done?
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 35128570
Reindexing organizes the data in the database to make searching it faster.
Updating statistics helps SQL Server to determine ABOUT how many records exist in a table or index.
Backups are necessary and if you have the database in full recovery mode without doing transaction log backups then the log will fill forever.

0
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 
LVL 3

Author Comment

by:pma111
ID: 35128611
I know there is the sql server best practices analyzer, does that identify if this sort of thing is being done or not? And does it only report on things that are essentially risks - or other stuff too?
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 35128679
I don't know.  I've never used it.
0
 
LVL 3

Author Comment

by:pma111
ID: 35128715
no worries.

on the comment:

Updating statistics helps SQL Server to determine ABOUT how many records exist in a table or index.

What is the real risk if you dont do this? Excuse my ignorance on statistics its not a concept I am familair with
0
 
LVL 3

Author Comment

by:pma111
ID: 35128724
I assume a process whereby re-indexing takes place on routine basis is more beneficial on larger databases? What is your recommendation on how often to reindex?
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 35128733
Statistics is what SQL Server uses to help determine the best query plan.  If SQL Server expects a particular table and criteria to return 5 rows, but instead it returns 5000, then the join type that it uses in the query may be completely wrong.
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In this article, we’ll look at how to deploy ProxySQL.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

752 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