Dave,

right now, a bit confused. "The trace file wont tell you how many transactions there have been , for that you need to summarise the perfmon data"... any idea how...

Dave,

saw your status online. I tried the Server side trace in test server. I have saved the trace script ouput (as .trc) file. From that, how can i get...

Yes, tried import of DTSX files from msdb(test) to msdb (prod). But since the server/dbnames are different in test and prod, I have to manually change all the connections. Problem...

...................SQLServer:Databases(DBNAME)\Transactions/sec"

"06/17/2010 01:16:08.825"," "

"06/17/2010 01:16:28.828","0"

"06/17/2010 01:16:48.830","0"

"06/17/2010 01:17:08.833","0"

"06/17/2010 01:17:28.835","0"

"06/17/2010 01:17:48.838","0"

This is an example. How to interpret this. I ran a Select statement, then an Insert. When i ran the Select query, a...

Thats a Lightning quick reply. My requirements are to get the No. of TXN count as well as the corresponding queries. Initially, even if i get the TXN count, it...

I need to determine the Number of Transactions a DB faces in a single day.

Thanks a ton. Certainly would try the Trace option. Presently am trying the below method for testing:

Using a job which queries the sys.sysprocesses to get the query text and scheduled...

Thanks Dave. I saw the post and the script, Will try it in test.. still do you have any other options. I think there are many DMV's from which the...

Thanks for all the immediate response.

Profiler is resource intensive. If there are no other viable options, then Profiler can be used. yes i need the data during the prod hours...

I do need your script. If possible post it

I am opening the DTS Package in Client PC's. We won't use the server directly.

BALAJI1 IS A table which would contain the records present in the excel sheet.

I am Balaji new to this discussion. My Code is::

exec xp_cmdshell 'copy C:\templates\BALAJI1.xls C:\export\BALAJI1.xls'

insert into OPENROWSET(

'Microsoft.Jet.OLEDB.4.0',

...