Thats make sense to me Gail ... I will discuss with my team about it ..cheers mate 🙂

Hi Gail ,

That's a very good article !

I just wonder what about if I need to monitor for 3 days ( from Wed until Friday ) ?

In that article giving...

Thanks Gail

Thanks Eri

Thanks for the reply

I came across this query from Google :

SELECT TOP 20

qs.sql_handle,

qs.execution_count,

qs.total_worker_time AS Total_CPU,

...

Excellent . Thank you !

I see. Thanks for the explanation . I will change the autoclose option soon !

Have a nice weekend 🙂

Thanks for the reply , really appreciate it and sorry for my late response ..

Actually the database AUTOCLOSE setting is TRUE. Would it be the cause ?

Cheers,

Thanks for the reply 🙂 That's kind of you

hmm I checked D:\ it is 8 GB free of 10 GB and E:\ is 7 GB free of 25 GB...

Guys thanks so muchhh for the explanation ?...

Btw i hv just posted a new topic about “ Database can’t be accessed “ but no one replied yet ? . I...

Thanks for the reply , Appreciate it !

I just checked the number of pages is 500 something for two indexes and the other one is 1000 something .. So should...

Thanks for your suggestion 🙂

Thanks for the reply . Appreciate it !

How do I measure it ? using SQL profiler for 3 hours each - Before and after changing ?

Cheers

Hi Jeff ,

hmm I just did defragmentation for all indexes in that particular database as discussed before .

It turns out the database file size is the same ( before...

Thank you! Appreciate it !