I have got one query from MSDN site to get CPU time and query text all process.

SELECT total_worker_time/execution_count AS [Avg CPU Time],

SUBSTRING(st.text, (qs.statement_start_offset/2)+1,

...

Welsh,

I have read that posting.

I have tried to get query text of execution completed process.

select text

from sys.dm_exec_sql_text(most_recent_sql_handle)

where session_id = 1732

but i am getting following error.

Msg 207, Level 16, State 1,...

Thank you for all your suggestions and responses....

Jefy

I have taken hardware configuration from DELL SQL Advisor, It is given below.

DELL Power Edge server 2950

CPU - one quad intel processor 64Bit

RAM - 32GB

HBAs - 2 (Single Port Fibre...

hi Steve,

Right we didn't purchase any server. We are planning to purchase a server.

This is our first huge database setup. So we dont have much knowledge about SQL server resource...

We can use following 3 RAID controller arrays.

1. RAID 1 - OS and backups

2. RAID 10 - tempdb, system dbs, data files

3. RAID 1 - Application data and log files

what...

Hi Steve,

You mean combaine SystemDbs, TempDB, Application database and Transaction log and store in RAID array, is it? We will not get any benefit to split these into 3 sparate...

We dont have any buchmark system. Right now we have loaded this 100GB data in a Testing SQL server, its configuration is 4GB RAM, one Dual core processor 2 SATA...

Please review following revised hardware configuration.

CPU :- 2 Quad core processors - 64Bit,3GHz or more

Hard Disk :- 4 RAID Contollers (SCSI fiber channel) and 4 arrays

...

Please review following revised hardware configuration.

CPU :- 2 Quad core processors - 64Bit,3GHz or more

Hard Disk :- 4 RAID Contollers (SCSI fiber channel) and 4 arrays

...

This is not a report data, it is a drug formulary data from all insurance companies, around 100GB data. We need to update 10GB of data every week with in...

Hi,

I can increase RAM to 32 GB per processor, total - 64GB.

Also i can change RAID configuration of DB storage hard disk to level 5 (Minimum space 2TB).

We are planning...