Thanks, this helps. One more thing related to replication monitor. I do not want to see any entries on replication monitor on my local machine, i use to look...

thanks.....thats what i am exactly askng to how to do it...are there any dmv's or functions or any other option inside replication monitor which can say me if the DATA...

thanks

we have exactly the same issue...MSFT told us the same...

thanks..ok....so based on the reviews so far seems like there is some improvement in performance in 2008. Seems like i will still need a third party tool for performance monitoring.

p.s:...

thanks

i have done enough testing after and before moving them, in my case moving is not the solution. Thanks

thanks Manu..is num_of_reads gives the total reads since the server was built or restarted? I think since built because even after i recycle the server , the number was...

thanks..Gail but its really hard to point a time where there is heavy usage. I will still try and let you know.Thanks

xp_stopmail

recycling ONLY the dbmail worked..thnaks

GilaMonster (9/21/2010)

---

Tracing for 8 hours gives you far more data than you can manage. If you read the articles i wrote, you'll see i recommend 30-60 minutes at a time....

thanks all, but how often do i do it? I thought of doing in once in two weeks on a typical business day for 8 hours with intervals of 15...

thanks for the replies. Yes the result is same after multiple runs, the indexes were enabled. When i backup and restore the same db there is an option under the...

selecting the option "Use Index" has helped. I am not sure why did it help. I have another post with more detail results. Please check http://www.sqlservercentral.com/Forums/Topic980901-146-1.aspx.

Thanks