doesn't that give I/O #'s for processes since they were started ???

I want to take a quick snapshot and get that I/O for everything.

I have looked but none of these match up with the Task Manager "sqlserver.exe" process and the memory it is consuming ?????

Wrote this to answer my own question.

Works quite well.

/* INSERT SCRIPT IN WHILE LOOP WITH TRANSACTIONS PER SECOND CALCULATION */

DECLARE @i int

DECLARE @begindate datetime

SET @begindate = GETDATE()

INSERT INTO begindate(begindate)

VALUES(@begindate)

SET @i...

Ok. This is what I am trying to do.

I want to setup C Names (common names) for my development SQL Server 2000 box. This is what I have setup.

6 Instances:

Default

Inst1

Inst2

Inst3

Inst4

Inst5

On...

understood.

where is UDP "1434" configured ?

Also, from BOL:

Net-Library:

TCP/IP Sockets

Default instance network address:

TCP Port 1433

Named instance network address:

A TCP port is chosen dynamically the first time the MSSQL$instancename service is started.

where...

1434 ???

Our Client Network Utilitiy --> TCP/IP (1433)

Server Network Utilitiy --> Default Instance (1433), Instance1 (1113), etc...

1434 is not there anywhere ?

Also what is UDP ?

"Port Assignment: Active Server acts as a listener and keeps track of all other Instances running on the system."

- Microsoft

is there an "active" server in this ?

one server that directs all port traffic for all Instances ?

What about blocking and locking here ?

also,

what is the difference between Auto Create Stats and Auto Update Stats ?

"I suggest especially on large databases leave auto update on but do run sp_updatestats once a week to make sure you get as much performance out of it anyway."

which one...

no performance complaints yet.

I have from Friday 8:30pm to Monday 7:30am for downtime.

what do you think ? create the jobs ?

do i need to run sp_creatstats and sp_updtestats -->...

the committed transactions are removed and put where ?

what is contained in the T-Log backup exactly ?

must be a registry setting somewhere.