Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-13 : 08:14:28
|
| M Iftikhar writes "HI Guys.I am iftikhar and DBA in a small company. I have a database records round about 1 millions.But now database is working too slow.I have done several activities like removing log, shrinking database and refreshing by making new database. But the still perfomance is slow.Please help me. I am waiting your answer Best Regardsyours truly.Muhammad iftikhar" |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-13 : 09:05:35
|
| you haven't given us any information we can use to help you.what exactly is slow? I am assuming a query.post the query, post the DDL for the tables it uses (including indexes)-ec |
 |
|
|
mallier
Starting Member
24 Posts |
Posted - 2006-02-13 : 09:07:16
|
| Is that database is indexed correctly for better perfomance? If not, u have to look into that.if it is properly indexed,have u tried reindexing ur database,do it at non peak time.cheers,http://mallier.blogspot.com |
|
|
|
|
|
|
Database Performance