Mike01 (5/11/2011)

---

Hopefully the table and the Archive able are partitioned and have the same layouts, constraints, PKs, filegroupings etc. If this is the case, then you could swap...

mika.sutinen (2/28/2011)

---

Hi,

How much you see in Total Server Memory counter? That tells you the current memory consumption and Target shows how much the SQL Server will eventually try to use.

It...

thanks for you reply,

My server has

128 GB of RAM,

Windows 2003 R2 (x64),

Sql server 2008 R2 (Data Center x64),

Min & max server memory =100,000 & 125,000.

Target server memory(kb) shows...

any body can help ?

check this out : http://www.red-gate.com/products/sql-development/sql-doc/

Check queries that have high cpu usage using activity moitor, then by thinking on execution plan u can solve problem. sql profiler + advisor may also help u.

but u can shrink it without getting back up !

GilaMonster (1/12/2011)

---

Schadenfreude-Mei (1/12/2011)

---

True but from the posters first post it seems they are worried about log filling (and presumably subsiquent...

Hi all,

does it works ?

sqlbuddy123 (1/12/2011)

---

AFAIK, It should have the same effect.

...

Hi, Check these out, I think problem will solve !

Link1

Link2

Link3[/url]

HI,

I had the same problem and I changed some queries with [with (nolock)] and fastfirstrow ,... to reduce locking and rebuild with ALLOW_PAGE_LOCKS = OFF, ONLINE = on !...

check this out

this software is very useful,. it shows query locks.

after that you know who does these locks by the position you may need to use query hints like (nolock,fastfirstrow,...)

for...

CirquedeSQLeil (12/11/2009)

---

farax_x (12/9/2009)

---

I changed my search criteria (about wildcard ) and rebuild fts indexes every night. it works better but its not acceptable yet !

my sample query :

SELECT docId,DocSubject,docDate

FROM...

I changed my search criteria (about wildcard ) and rebuild fts indexes every night. it works better but its not acceptable yet !

my sample query :

SELECT docId,DocSubject,docDate

FROM tblDocument WITH...

anyone cant help me!!! :crying:

my boss will kill me :crying::crying: