DATABASE ISSUE

Question

Post reply

DATABASE ISSUE

balaji.ganga

SSCrazy

Points: 2280
More actions
August 13, 2010 at 1:01 am

#387574

Hi All,
Appications are running slowly, If any query's or sp, will take much more time to execute?
how can i arrest this issue? i have attached my dabatase details..
I would really appreciate.. if any body helpme...
Thanks
Balaji.G

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

What have you done to try to find the issue?

Are you getting any error messages?

Are you getting deadlocks?

Are queries timing out?

Have you checked the index fragmentation?

Have you checked to ensure stats are up to date?

Have you checked for blocking?

Is your disk space in good shape?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

balaji.ganga SSCrazy Points: 2280 More actions · Answer 2

while execute the query or sp, some times timeout expired came.

I have checked the fragmentation.. Some of the objects are heavily fragmented

Most of the objects are not upto date.

More Space available

There is no blocking

What i feel is, Shall i do the below activities

1. shrink a database

2. rebuild an index for all objects

3. update the statistics for all objects

Is it ok.. or else give me a suggestion

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

balaji.ganga (8/13/2010)
What i feel is, Shall i do the below activities
1. shrink a database
2. rebuild an index for all objects
3. update the statistics for all objects
Is it ok.. or else give me a suggestion

1. NO - do not shrink your database. That would not help for this case.

2. I would rebuild indexes, but it is not necessary for all indexes. Only rebuild the indexes that are necessary

3. Yes - update stats and also a dbcc updateusage could provide some good mileage.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

arr.nagaraj SSCertifiable Points: 6528 More actions · Answer 4

If interested please read http://strictlysql.blogspot.com/2010/02/database-server-is-slow-can-you-please.html%5B/url%5D

Regards,
Raj

http://Strictlysql.blogspot.com

balaji.ganga SSCrazy Points: 2280 More actions · Answer 5

Some of the unnecessary objects are available in our database.

So that only i would delete those objects and shrink a database

Some of the objects are heap.There is no constraint. I would suggest to development team to create a constraint for those objects

Is it right ?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

balaji.ganga (8/13/2010)
Some of the unnecessary objects are available in our database.
So that only i would delete those objects and shrink a database
Some of the objects are heap.There is no constraint. I would suggest to development team to create a constraint for those objects
Is it right ?

If you are absolutely certain that the objects do not belong in the database - I would work on getting them removed. This does not require a shrink of the database though.

If the objects are heaps, you should investigate if a clustered index is appropriate for those tables and create a clustered index. A clustered index does not imply constraint though and a constraint does not imply an index.

Once you create the clustered index, do not remove it (if you are doing it explicitly for defrag purposes ). Create appropriate clustered indexes that will persist in the database structure and be usable.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

arr.nagaraj SSCertifiable Points: 6528 More actions · Answer 7

Removing unwanted objects is a good thing, but thats less likely to be the reason for your problem. Do a thorough analysis of the problem.

Start checking from Task manager , perfmon ,DMVs to find which aspect of your server has problems.

Regards,
Raj

http://Strictlysql.blogspot.com

balaji.ganga SSCrazy Points: 2280 More actions · Answer 8

Thanks for all your valuable comments

Regards

Balaji.G

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

You're welcome.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events