Set up a trace and identify any query that hurts performance

Did you execute CheckDB as Gail suggested?

Does it open in management studio? are being able to execute the script?

binu

May be your account does not have appropriate permission.

Also can be a corrupt installation.

Create a .sql file using notepad and try double click it to open. Are you able to...

Micheal,

Do you see any additional message in the error log?

How do you take backup? Gui/T SQL? Local or network?

Please look at the link.

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/12/02/missing-perfmon-counters-using-64-bit-windows-mmc-32-perfmon-msc.aspx

webrunner (12/3/2009)

---

Hello,

What is strange is that the database backup files are in their correct locations. So it looks like the backups completed successfully. Yet the error has me uneasy that...

Tim, what you suggested will work for 5 people also, I think.

Declare @rank_test table

(

id int identity(1,1),

data...

500000 records is not a big table.

1) What is your configuration.

2) Please post the query and its execution plan to see if any indexes can help

This may not be optimal, but might help you

Declare @rank_test table

(

id int identity(1,1),

data varchar(250),

sales_man int null

)

insert into @rank_test(data)

select top 60 name from syscolumns

-- For the first salesman

update @rank_test...

What about the table that the procedure reads from? Does it change frequently? Some times when data changes enormously, the statistics becomes stale, the execution plan also becomes less suitable.

I copying is the problem, you can take a striped backup. Though its not advisable for regular backup plans (I corrupt file make whole set useless),

you can use this for...

Log backups will not reduce the size of the log file. It will only clear the file so that it can be reused

Run DBCC SQLPERF('LOGSPACE')

You will see the percentage used

Ajay,

What others are telling is right. If you are just looking at the possibility its fine. But you have plan to do it right out on a production database, I...

http://technet.microsoft.com/en-us/library/ms176056(SQL.90).aspx