really thaxx for reply but still i dont know how to use this query which u told me .will u plz clear it to me

so thaxxx

Really thaxx for apply still this error comes out.can we see all details which i need with this query which u give me

Msg 102, Level 15, State 1,...

plz check this table its wrong

select *from sys.dm_exec_sql_text

whats the right table

Hi,

just try this i think its useful for u

SELECT (a.cntr_value * 1.0 / b.cntr_value) * 100.0 [BufferCacheHitRatio]

FROM (SELECT *, 1 x FROM sys.dm_os_performance_counters

...

thaxx ,

but i cant find my result actully i need these results in one table .

hi,

will u plz try this query bcuase i am not sure that my reasult is fine according to my question

SELECT (a.cntr_value * 1.0 / b.cntr_value) * 100.0 [BufferCacheHitRatio]...

hi,

SELECT (a.cntr_value * 1.0 / b.cntr_value) * 100.0 [BufferCacheHitRatio]

FROM (SELECT *, 1 x FROM sys.dm_os_performance_counters

WHERE counter_name = 'Buffer...

hi ,

still there is error comes from this query as well

Msg 102, Level 15, State 1, Line 9

Incorrect syntax near 'b'.

Hello,

Thaxx for telling me ''go to SQL Server: Buffer Manager\Buffer Cache Hit Ratio, if you want to know the plan cache hit ratio, go to SQL Server: Plan Cache\Cache...

thaxx for reply ,but i dont want this i need some script bcuase we dont admin privellege for all servers bcause with query i need to know abt the health...

hi,

Really very sorry but still i cant do .will u plz tell me how can i solve this .

sorry for inconvenience.will u plz just edit this portion on query...

hi ,

Thaxx for reply but i know this how to export and import from dts its easy but i want to this learn with ssis .so will u...

Really thaxx for reply still there is error comes out

Server: Msg 208, Level 16, State 6, Procedure up_UtilDBGrowthRateSql2000, Line 90

Invalid object name 'dbo.up_UtilDBGrowthRateSql2000'.

what can i change now

Thanxx...

hi,

can we shring log files with ssms as well

thaxx

hi ,

sorry its not working

command run succesfully but there is no output comes out.

but i have done it now

its is in ''dbo.sysaltfiles''