nervermind. I was able to figure it out using below query.

select * from sys.dm_xe_map_values where name='latch_mode'

order by map_key asc

Correct.

I should have stated my question clearly saying..no use of adding index rebuild online option when we use web edition.

I see you clarified my question. Thank you 🙂

That means having a parameter like Index rebuild is of no use, correrct?

Thanks Jeff. The only thing which still i am thinking is how frequently I need to run this query as a job.

With that query it provides me max start...

Nevermind.. i just figured it out..

insert into auditorstable

SELECT I.StartTime,I.ServerName, I.HostName,I.DatabaseName,I.ApplicationName,I.LoginName,I.EndTime

,I.RowCounts,I.SessionLoginName,i.TextData

FROM ::fn_trace_gettable('G:\TestAudit\Testaudit.trc', default) I

where I.StartTime in

(SELECT MAX( I.StartTime) FROM ::fn_trace_gettable('G:\TestAudit\Testaudit.trc', default) I

)

Thanks Gila...

Thanks Grant and Gila for valuable information. I completely agree on your points.

The problem with my organization is lack of knowledge about RTO. More over we have is virtual...

Thanks John and Jack for your information.

But, this is what the O/P i am expecting....TO GET 4th column with difference in growth from datafilesize column...

name ...

That's great. Thank you for information.

Also, since my server is of Standard edition and not having any RCSI enabled or having Index rebuild ONLINE option, installing below hot fix should...

Thank Jeff.

But, why won't the space reverts back after index rebuild.

Thanks Ferry for your response. This is a data warehouse environment and we do not have any HA.

Based on previous statistics when we did maintenance it took approximately 14...

On the new server we did the DISKIO testings and on average i noticed is 6-10 ms. But, we didn't do the same testing in old datacenter.

Lowell,

Thanks, for some reason, i just got diverted. Re queried BY ADDING getdate() into my select query and was able to get my result. ...

I have already gone through it. But, looking for OLAP settings only. Currently i am testing with my environment by increasing and decreasing values.

Can someone look into this article and let me know is it really good to set tempdb auto growth ENABLED. It's just wondering me.

"http://msdn.microsoft.com/en-us/library/ms175527.aspx"

I am planning to allocate a...