Also:

Add a separate drive for index filegroups. I/O throughput can benefit when non-clustered index operations are separated from the rest.

In my workplace, we also keep separate drives for full and...

Create as many tempdb data files as there are processors. Create them equally sized so that they take up pretty much the entire tempdb drive - perhaps with a couple...

Greg Edwards (2/8/2008)

---

Mario is probably right about the double hop.

Can you setup Kerberos on the machines?

http://support.microsoft.com/?kbid=319723

We have IIS and RS on one machine, SQL and SSAS on another,...

I may not be able to check on this topic for the next 10 days or so due to something unexpected.

Pls post any feedback here, and I will get to...

Lester Policarpio (2/7/2008)

---

For data i used dbcc showfilestats

use tempdb dbcc showfilestats

-- For DB Size : (totalextents*64)/1024

-- FOr DB Used : (usedextents*64)/1024

-- For DB Free Space :

--((totalextents*64)/1024)-((usedextents*64)/1024)

FOr log...

Steve Jones - Editor (2/7/2008)

---

Sorry, forgot that was for log space only.

One thing you could do is track the space in tempdb using a proc and either store it in...

After enabling remote errors, the error message changed to the following:

An error has occurred during report processing.

Cannot create a connection to data source 'Dynamic_Connection'.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I...

Thanks...

Can we set an alert once tempdb *allocated* space (not the actual size of the file, which in my case stays constant) reaches a certain threshold?

I don't think it's possible...

Thanks Steve,

I'm interested in tracking size over time, specifically tempdb used space over time. I did not have alerts in mind, but that sounds like a good idea.

As I mentioned,...

To clarify, MS will not be releasing any new...

Also, try installing under the local admin account (as opposed to a domain account). The local admin has superior privileges, which might help you get over the hump.

Make sure that the account you are using to do the installation is local admin on the server machine.

The latest post-SQL-2000-SP4 rollup, version 8.0.2187, has a lot of the fixes required, including a fix for the AWE bug.

Microsoft has extended support for SQL 2000 SP4 to 2013, although...

From "Use Missing-Index Groups for Query Tuning", SQL Server Mag., April 2007, by Kalen Delaney

"You can disable the missing-index feature by starting an instance of SQL Server using the -x...