we have 6 drives in that server

here we dont have the san setup. we are using internal storage.

here i am sending the sql log

2013-08-28 12:56:50.17 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)

Apr 2 2010 15:48:46

Copyright (c)...

here in event viewer we are getting message like " server 'server name' is terminated unexpectedly"

we are getting this message only

no we have not changed any accounts here all are running under same account (network service account).

for sql error log we have restarted the service now it is showing that...

in previous post i have mentioned the event viewer log file.

here ia m sending the sql error log as well.

2013-08-28 01:47:51 - ? [100] Microsoft SQLServerAgent version 10.50.1600.1 ((Unknown) unicode...

Thank you all temporarily the issue solved. we have created the cluster index on table then it is solved.

no we are not executing anything still physical memory usage is showing as 95.45gb.

i have checked for blockages there is no blockages.

how can i solve this memory issue.

here we found that memory usage is showing as 99%

we have 26 columns in that. the execution plan is showing as table scan

how can i find the fragmentation on this single query

here in this table 9112177 records are there 6.3gb data is available.

thanks for your valuable information

in transactional replication with updates can we change any modifications on subscriber and those will reflect in publisher as well

Thanks for your response

as per my client requirement we have one table which is having 5cr records presently we are given the access to users on production.

they want to reduce...

Thank you very much Monster