Thanks for the script...

I did some modifications as per my requirement and it works like a charm.

But, when i scheduled this as a job i am getting a blank report....

-- Monitoring Memory Usage

http://msdn.microsoft.com/en-us/library/ms176018(v=sql.105).aspx

http://www.sqlskills.com/BLOGS/PAUL/post/Performance-issues-from-wasted-buffer-pool-memory.aspx

-- Find memory util with the below query

SELECT total_physical_memory_kb/1024 TotmemMB, available_physical_memory_kb/1024 as AvailPhymemMB,

total_page_file_kb/1024 as TotpagefileMB, available_page_file_kb/1024 as AvailPagefileMB, system_memory_state_desc,

(select memory_utilization_percentage from sys.dm_os_process_memory)as memory_utilization_percentage

FROM sys.dm_os_sys_memory;

--Look at the values for these parameters;...

Hope u know me ;-)!!

Port no (incase if they aint using the default one).

&

Service Accounts

I dont think you can rename the instance without uninstalling it. !!

Try going through these links for the architecture.

http://msdn.microsoft.com/en-us/library/ms190381(v=sql.105)

http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx

I am not sure abt the cost diff though !

Thanks Jack for your quick response.

I am looking into your suggestions.

In the meantime, how abt configuring mem for SSRS (http://msdn.microsoft.com/en-us/library/ms159206.aspx).

Thanks

Thanks a lot for your reply Jack.

But unfortunately I cant cut down sql server memory now as its hitting peak levels now itself.

As a temp solution, before SSRS migration im...

This file will be located in the same folder(on the secondary/standby server) from where Log shipping is picking the transacation log(*.trn) files for restore.

I guess i was lil vaugue in my expln of the prob...

Its like, i am trying to get the time stamp from the log backup file created by log shippin...

and...

Thanks a lot Markus...

This question came as per the requirement from the AD team...so i guess, they need to create a number of profiles as per the app requirement...

Thanks again!

I could find it...still, thanks a lot for the reply...

In addition, i found that, you need to make the TNS entry into TNSNAMES.ORA and then try a pinging the server...

I guess, it doesnt really matter to which drive it writes to...Its a very small log file which gets populated as and when job executes and shouldnt be causing any...

even i have herd abt this...bt needs to see if client agrees to it...

😀

cz we hardly do this copyin n restore...

lemme see if i cn push this in the next...

i ws having issues in copying the files over network.

My bak files were of size 20GB+ and copying failed multiple times saying "path is too deep" and all.

Today i tried...