Is your server a cluster?

Are your other drives shared?

What do you mean array 0, 1, 2, 3, ...?

If your configuration will be built on a single RAID 5, there is no difference in performance.

This kind of task always takes disk space, I mean a lot.

You may shrink your database before starting your re-indexing.

You may try to drop the index and re-create it. As...

How about this one if you run manually?

sp_msforeachdb 'EXEC sp_spaceused'

Although a virtual machine may have ample resources, each component may not have enough after resource allocation. You need to check it.

OK, let us assume each of your system has...

I would like to try to replace AND by OR.

It will be easy if your table has a column with timestamp data type. Here is an example.

DECLARE @Date DATETIME

SELECT @Date = MAX(DateUpdated) FROM myTable

IF @Date > DATEADD(d, -1, GETDATE())

BEGIN

...

DBCC OPENTRAN can tell you what tasks are in process.

There are two levels of monitoring. One is on SQL database server. Another is on the OS level.

To check the connection to an SQL Server, you can build SQL Profiler,...

Betty Sun (3/7/2008)

---

thank you both for the replies. Yes I can view all the tables.

OK I will use full name to create a table.

The question is: is that possible, I...

If your whole server is configured as RAID 5, separating your data and log files will not enhance performance.

I have no solution. I mean you may have to login the server to connect the SSIS.

Here is a link. May it help. But I still wish someone had a...

Could you add your html code in your CASE clause if you use web to generate your report? I am just wondering.

Sometimes, after killing a process, we can see rollback. It stays there forever.

I came across the situation below.

I killed a LiteSpeed backup. The status of the process stayed in rollback...

What is your hardware structure? What RAID do you use?