Hi, I have a question regarding rebuild and reorganize index. We have created a job for rebuild index on a weekly basis but our client has asked for creating one job mid week for reorganize index as well. Could this create any issues in performance?
Hi there. I have had an Alter Index Rebuild running for 6 hours. The database is online. The status of the Alter Index process is “suspended” with a wait type of LCK_M_SCH_M and it appears there are 100 or so other processes being blocked by the SPID of the Alter Index Rebuild. Is there a safe way to abort the Rebuild or should I wait till it finishes? I cant tell if its even doing anything. BTW the database is 30-40GB. Any advice/tips? I obviously know now I should have taken the db offline first.
while we are in rebuild job in production region ..queries are getting good performance.. but recently they moved reorganize(smat index) job queries are taking more time (more 100 time...one of the query when compare to rebuild) to executive.. below are the job equation... fragmentation greater 5 to less than 25 then reorganize ...if fragmentation greater 25 then rebuild.... Could you please let me know what are queries are taking more time when we moved to reorganize ...its real production burning issue.Thank you
Hi, I'm afraid your question isn't coming across clearly at all. If you'd like to submit your question, please head over to SQLWorkbooks.com/ask and send me more info. Please be very clear about exactly what is slow (queries involved in the maintenance, or other queries), if you wrote the maintenance scripts yourself or are using some you found online, and exactly the nature of the problem you're seeing.
Thanks so much , your making me grow day by day... liked sorry loved your sessions.
Aravind.
Superb presentation. Coolest DBA ever :)
Awesome content and great presentation - Appreciate it !!
Just realized I may be going to a new job without SQL enterprise for the first time in my career and im very sad haha
Thanks for this video .... can you please explain about Partitioned Indexes and how to manage them
thank you unicorn..... 😊
Thanks!
I wonder if you would ever clear the interview with your bed time stories?
Hi,
I have a question regarding rebuild and reorganize index. We have created a job for rebuild index on a weekly basis but our client has asked for creating one job mid week for reorganize index as well. Could this create any issues in performance?
I have a 250gb database and when I run reorganize it takes forever my fragmentation level is high more than 99%
Can we perform 10 databases index rebuild parallelly with different maintenance jobs in a single server in SQL 2014 standard edition??
lost what was the Question, probably for my level, need bit fragmentation with answer
Hi there. I have had an Alter Index Rebuild running for 6 hours. The database is online. The status of the Alter Index process is “suspended” with a wait type of LCK_M_SCH_M and it appears there are 100 or so other processes being blocked by the SPID of the Alter Index Rebuild. Is there a safe way to abort the Rebuild or should I wait till it finishes? I cant tell if its even doing anything. BTW the database is 30-40GB.
Any advice/tips? I obviously know now I should have taken the db offline first.
Only theory is boring to listen...it would have been better if you show in practical. 😊
while we are in rebuild job in production region ..queries are getting good performance.. but recently they moved reorganize(smat index) job queries are taking more time (more 100 time...one of the query when compare to rebuild) to executive.. below are the job equation...
fragmentation greater 5 to less than 25 then reorganize ...if fragmentation greater 25 then rebuild.... Could you please let me know what are queries are taking more time when we moved to reorganize ...its real production burning issue.Thank you
Hi, I'm afraid your question isn't coming across clearly at all. If you'd like to submit your question, please head over to SQLWorkbooks.com/ask and send me more info. Please be very clear about exactly what is slow (queries involved in the maintenance, or other queries), if you wrote the maintenance scripts yourself or are using some you found online, and exactly the nature of the problem you're seeing.
I got the question from the online form, I'll respond over there. Thanks!
Showing any practical session. it's should be good. More talkative !..
All over the place, very hard to follow -- if you're explaining.
Too much explanation.