I am not familiar with Veritas Clustering but this is happening to me for clustered and unclustered servers, win2k or win 2k3, all default installations.

All my servers are registered in EM with NT Authentication, the issue is that on some servers a different account then the one that I am log in into my PC...

I am working from a Win 2000 workstation, I couldn't find the User Name in the options on Task Manager.

I am talking only about registered servers in EM or regular...

I have this annoyance with a Win 2000 cluster (SQL2kSP3a) and a Win 2003 (SQL2kSP3a)

I am experiencing the same issue with some of the servers that I am taking care.

I guess is that is has something to do with the network latency/DNS/AD configuration.

Il looks like you have to change some HDs.

Chris, it looks that you are right. I done some testing and indeed after the truncate the pages are still there with data in.

The only differences that I could...

I have seen many posts regarding SP4 negatively inpacting queries/stored procedures speed. If you can try on a dev server with SP3a not SP4.

So, if I understood it correctly you think that instead of delete and write it is just an overwrite.

That would make sense from the writing speed and page allocation...

I am not sure what you mean by

"The data in the page does not need to be cleared since that page will have a slot offset array that points to...

I found also in MSDN that

"TRUNCATE TABLE immediately frees all the space occupied by that table's data and indexes."

that will indicate in my opinion that indeed there is some mechanism...

thanks for the replays, I don't think they are reallocated since they contain data, so somehow all that data pages have to be deleted at some point otherwise will result...

Hi,

What was the MS support solution and explanation for that error?

there is a cluster.log on c:\winnt\cluster\

I think the server EventViewer will tell you that.

If this is the case with a fairly simple VB Script you can monitor the EventViewer and send alerts when this...