thanks for the comments 🙂

but activity monitor and sp_who displays number of currently connected users, right?

isn't there any way to get the maximum number of users generally? or...

No 'm sure I've connected to the correct server

There's one point, I haven't restarted server after moving files. is it the case?

yes I connected to that and executed a few queries 😎

bjhogan (2/16/2009)

---

See if this query gives you what you are looking for. I have found ordering by execution_count useful in the past especially for those queries that might execute...

Lowell (2/15/2009)

---

you really need to start with creating a trace with profiler....create one and let it run for a while...I'd say one business day.

with that, it will give you every...

Lowell (2/15/2009)

---

you really need to start with creating a trace with profiler....create one and let it run for a while...I'd say one business day.

with that, it will give you every...

yeah got it

Thank you paul 🙂

How can I do that?

Thanks all for the comments 🙂

Could you please explain how I can perform that?

for maintaining proper PK-FK...

Thanks all for your useful comments 🙂

My traceid is...

I was going to move tempdb when IT manager questioned me about the large size of tempdb!

our tempdb file is 12GB, and he says it's so strange and...

Thanks again Marios:)

Thanks all for the comments 🙂

Have you tried running the trace as a server side trace rather than through profiler? That should have noticeably less impact.

1) Start the trace...

Thanks a lot Marios 🙂

IS there any risk in configuring tempdb while there are so many concurrent transactions on databases? Or, I shall do that when no one is connected...