thanks for reply...sorry to ask this dumb question..but when can u say that CPU usage is high...i know sql server is using 98% of cpu...but lets say from the profiler...

i do have dash board reports.....i am looking at report for avg cpu...but i need some suggestion on how to analyze because its pulling the data from yesterday also...if you...

will do the same...thansk

compare the query execution plans of the cursors from your old and new...im sure there should be some difference in the plan...

thanks...i would try and let you guys know..

thanks. One of the issues what i can forsee by using sql agent is that ,lets say i have 200 jobs then i will need to manually add agent operator...

got it.Thanks !!!

thanks leo and brandie for the response..

Leo:

You said it reads the log...which process reads? do you mean ldf's are read?thanks..

?

thanks...so...intially snapshot agent will create the files and whenever subscriber is set up distribution agent will read those files and apply them to the subscriber through "snapshot agent job"....but then...

this was in general...assume through maintenance plan

thanks

i was reading through them now...yeah from the article..i do understand now that clustered index is actually the table itself....thanks for prompt response.

thanks ..so lets say there is a table of size 10 gb...with a clustered index...does that mean the clustered index size is 10 gb?

thanks..