sqlnsg (12/21/2009)

---

The following is the sql 2000 version

Microsoft SQL Server 2000 - 8.00.2282 (Intel X86) Dec 30 2008 02:22:41 Copyright (c) 1988-2003 Microsoft...

Hi,

Please read the 1'st link added in my signature this ll...

Sourav-657741 (12/19/2009)

---

Presently I'm using the below t-sql to manually rebuild the indexes of all the tables in the db:AdventureWorks

use adventureWorks

GO

EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"

GO

===================================================================

How can...

Ur welcome...:-D

Hi,

Run the following query & find the blocking,opentran...

select open_tran,* from master.dbo.sysprocesses where spid >=51 and blocked<>0

Did u adjust the maxdop...

sqlnsg (12/19/2009)

---

Error 1229: Process ID %d:%d owns resources that are blocking processes on scheduler %d.

I have refered the following article but its of no use , currently i have...

Hi,

Check the following KB this might be help.

KB-976413

hydbadrose (12/17/2009)

---

Hello,

There i a performance problem. the scripts are running very slow. The stats are not out dated. database space is ok. I checked the MDF disk space and its...

Our Production DB is in SQl 2000 Sp4 , recently we had numerious performance issues , we use to get process id error from spid 4 (lock monitor) , I...

jason.stephens (12/16/2009)

---

I wrote a script to dynamically reorg/rebuild indexes and I ran it. The tlog grew out of control and ended up running out of space. I would like to...

Search under the Script section in our SSC...

Just an overview of server, it has 32 gb RAM runs on 64 bit 2003...

Yes,I agree with u.

You need to investigate the index proposals and pick the one(s) you think will...

Just an overview of server, it has 32 gb RAM runs on 64 bit 2003 OS with 64 bit sql 2005. I see that the page file is maxed out...

dpt,

I have suggestion to run the performance dash board and find the missing indexes create all the missing indexes and test it in ur testing envorinment.

If it's good go ahead.