?
Solved

Performance

Posted on 2011-03-14
8
Medium Priority
?
483 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
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

864 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