You can use the Performance counter (inbuilt winodws Tool) and Performance related DMV's to get sql server workload .

please refer following PPT , it may help you

http://www.google.co.in/url?sa=t&rct=j&q=performance%20counters%20for%20workload%20in%20sql%20server&source=web&cd=5&ved=0CEMQFjAE&url=http%3A%2F%2Fanildesai.net%2Fwp-content%2Fuploads%2F2010%2F05%2FSQL-Server-Performance-CodeCamp-2010.pptx&ei=E5S4UM2pG8HsrAeB_YH4DA&usg=AFQjCNHzo7fjSNcONdgPNNHfIRx38uc-Aw&cad=rja

is that your Production server ?

But please do post the exact error of your jobs .

use the method Gail provided in last post.

abhishekkulkarni1284 (11/29/2012)

---

but have one concern that it might bleed into business hours affecting the performance of applications. Not sure though, how much it will affect, i can try though.

Thanks...

abhishekkulkarni1284 (11/29/2012)

---

Hi, We have a Database Integrity Job and Backup Job that are scheduled in a gap of 6 hrs, with the DI job kicking off first. However conidering the...

runal_jagtap (11/29/2012)

---

I did, Execute the Alter Datafile query

i got outut - the files are moved . next time when DB starts..

Fine enough..then i took the DB to OFfline state..

Now i...

1) Space Issue

2) Imagine if you have 100 of transactional log backup after full backup.Now if you want to restore database or in case of disaster ,you need to...

http://msdn.microsoft.com/en-us/library/ms189275.aspx

http://www.codeproject.com/Articles/380879/About-transaction-log-and-its-truncation-in-SQL-Se

what is the output of

select spid,db_name(dbid) from sysprocesses where db_name(dbid) ='DatabaseName'

Thanks ,good question.. learn first time about STUFF and then answered it 🙂

to get when your SQL server restarted last time

SELECT[sqlserver_start_time]

FROM[sys].[dm_os_sys_info]

To get when databases accessed last time , use the script provided by Lowell in below thread

http://www.sqlservercentral.com/Forums/Topic1280879-1550-1.aspx

Not sure which version of SQL server you are using exactly 😉

its different in post and different in Subject line

No,You can not check the index usage stats for a DB in SQL server 2000 ,as there is no DMV's in SQL server 2000 .

You can use the Profiler,...

that isn't like you are logically...

The test result i post,was done on table without primary key .

in OP's case,he want it to alter column which having primary Key .

if you Use

alter table tablename...