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 |
|
bissa
Starting Member
32 Posts |
 Posted - 2012-05-11 : 00:49:01
|
| hi,I have some tables index can't be rebuilding, reorganizing with the maintenance plans, when I check the physicial statistics, it is still marked as it needs rebuild or reorganize but what ever I do, it doesn't change. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
bissa
Starting Member
32 Posts |
Posted - 2012-05-11 : 03:46:09
|
this what I get, sorry my info is not much, but I keep reading in search ^^My DB suffer from slow downs only when there is a high load on it, I don't know where the issue. I keep trying different things hoping to improve performance. it is not resource issue, as I upgraded my server to a faster machine but nothing improved.I'm using ODBC SQL Native Client as connection for the DB, I read that there is problem when using ODBC with MSSQL standard edition but with SQL Express this slow downs doesn't appear, I don't remember getting slow downs before when I was using SQL Express but once I upgraded to MSSQL Standard edition, this slow downs appeared. I had to upgrade due to limit size of SQL Express :( sorry for asking much |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
alternative way to rebuild, reorganize indexes?