if this just a select? maybe try finding the biggest col and doing a convert or cast on it so that it works

Does not make much since to me when...

if this is not fast enough your other option is to create a full text search catalog, add the needed tables and col....then do a search on contains....this will more...

Linked server is your answer....

make sure on the remote server that you are logging into you have a created a user with rights that you require...example you want user A...

shaunspad (9/20/2010)

---

456789psw (9/20/2010)

---

This pretty much tells you that this instance is ok,

So there were a few places were it dipped below. Does this mean that if I see it...

This pretty much tells you that this instance is ok,

you should run profiler and capture all the other instances at the same time....that way you can run one trace....save you...

sounds to me like you just need one dev edition for devapp1.

if your developers only need to access devdbsrv1 and need SSMS you can install sql express and then...

after you get it up and running run this script, this will tell you the insert vs the seeks/scans.... only keep and index if you have more seeks then inserts....some...

mpalaparthi (9/20/2010)

---

Hello SQL Server Experts,

My questions are:

1) Does it sounds good for a DB size of 7GB there are 1000 objects. This is not a critical application. how do I...

hard to tell with just this since its a snapshot many things can happen between snapshots, example what if the OS ran out of memory a min before you ran...

I know exactly what you mean now....I was able to get the MS to do in I think 2000 but havent been able to do it since...

Start a new thread...

In 08 you can run the activity monitor, under process you can filter the DB then look at the resources.

There is wide range of items to look at there.

I have used it a lot as well, but so much of it is really hard to tell. you need to test it and check.

Using 2005 FT does not...

If I right click on the index it says 80.41 % for page fullness but under

sys.dm_db_index_physical_stats I get 98% for avg page space used? I thought they would...

This is simple....run your perf mon look for Page life expectancy(sql server memory), for each SQL instance. make sure the PLE is no less then 300, preferably higher like 1000...

Here is good link...this will walk you through the whole thing...4 parts

http://www.mssqltips.com/tip.asp?tip=1687