Hi ,

1. keep tempdb database in separate drive

2. use performance monitor to monitor the tempdb size and activities

3. use the following DMV to monitor the tempdb.

...

Hi...

How do I setup the partition for this table....

Pls share with me any best way to implement the partition.

I am bangalore, India.

My requirement is different.

Only one database at this time.

what about the logshipping option in between 2000 and 2005

Thanks,

It is not part of the Cluster aware.

This is stand alone system. We need to check the db alive throught Nagios monitoring tool.

I need a query to check whether the...

Is it alive or not?

Thanks to All

I ran the checkdb in my prod db and I got the below output.

CHECKDB found 0 allocation errors and 0 consistency errors in database 'Sales'.

DBCC execution completed. If DBCC printed...

I ran your command and it does not showed the filegroup.

but the filegroup name is reflected in the sysfilegroup system table.

Thanks,

Server: Msg 5009, Level 16, State 3, Line 1

ALTER DATABASE failed. Some disk names listed in the statement were not found. Check that the names exist and are spelled correctly...

ALTER DATABASE [Sales] REMOVE FILE [INDEXES]

ALTER DATABASE [Sales] REMOVE FILEGROUP [INDEXES]

Both are not working....

Thanks,

it was taking around 10 mins and that contains around 10 millions records

Thanks,

I meant serverside trace for deadlock..

Thanks,

Thanks Ashok