Default.

Thank you all for taking some time out to reply to my post.

So is there any other way this problem can be solved?

Thank you all for your reply. I was just curious about that since I have read articles in the past where DBA's prefer using SSMS to access the DB but...

I just found out it's not a DB issue. They are having some issues with the application. Thank you all for helping me out.

The Max logical read I see is 3 and I did right click and opened up the execution plan but it says "clustered Index Seek cost 100% and that's it.

I right click on the server and then activity Monitor. I am looking in Recent Expensive Queries. Which column do I actually have to look out for?

dave hants (2/13/2014)

---

You could look for the query on the server to try and identify what table it was accessing.

For example, if you have Windows Server 2008 then...

Yes, it is the same post and I have no idea which store proc or table its calling. I am still working on getting it from a developer.

I am sorry I should have been a little more clear on this. Users are having issues with page loading and it is taking them somewhat 30 seconds. For some...

What if there are 4600 pages?

Thank you guys for replying to this post. However, I ended up creating a dedicated account to do DBA chores so I don't have to RDP into servers.

TheSQLGuru (2/11/2014)

---

Web search is your friend. I searched Google for the words

ssms login other domain user

and came up with a number of references to using the windows Run...

All the other servers we have use different domain name. I can login into the server with SQL authentication but not windows authentication. Thanks for the reply.

I do understand the fact that it will rebuild all the indexes regardless how fragmented they are but my problem is that I am not good with powershell or writing...