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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-06-11 : 06:25:27
|
| Dear Expert Tara,i'm new to production environment. here in one particular application we are getting timeout error since yesterday. so i've palnned to defragment the indexes. i've read your article previously and taken the code. thank you very much for the code.now my doubt is ...ours is an production environment with 24x7. the data in the database is approxmately 40gb. mid night 2:00 to 2:30 i can do something as the server is free at that time. so can i run the script at that time? is that 30Min is sufficiant? will the problem resolve with that? or still i need to do something like index rebuilding?please help me Dear tara,peso,madhi,harsh,rickd,mvj,visakh...and all other experts.http://weblogs.sqlteam.com/tarad/archive/2007/11/27/60415.aspxArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-06-11 : 06:28:54
|
Which version and edition of SQL Server 2005 are you using?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-11 : 06:43:01
|
| sql server 2005 standard editionArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-11 : 08:05:42
|
| Dear All,i got the error while running the scriptsyntax error.please let me know any changes are thereArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-06-11 : 08:08:26
|
What efforts have you made to debug the script?The script works for me, but then again I am using the script on SQL Server 2005 as tara has stated in the user guide.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-12 : 01:07:19
|
| i did not tried to debug the code as it is written by Tara.i think the reason for the error is because of this...FROM sys.dm_db_index_physical_stats (DB_ID(@dbName), NULL, NULL, NULL, @statsMode)it is saying that syntax error at '('please guide me to correct this. and let me know that is this enough? or i need to run the rebuild script also?please help me here. ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-12 : 01:20:14
|
| Thank you very much all...i've solved the problem..the problem reason is compatibility levelArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-06-12 : 02:22:30
|
| Dear all,the script will take how much time on the database around 40 gb? any approximate time?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
|
|
tkizer script