Perry Whittle (4/9/2014)

---

Try this

SET NOCOUNT ON

DECLARE @sql NVARCHAR(MAX)

SET @sql = ''

SELECT @sql =

'--======================================================================================' + CHAR(10) +

'--==== IMPORTANT: Before executing these scripts check the details to ensure they...

Lowell (4/9/2014)

---

as usual, it depends on what you are looking for: object level permissions? ie does user mydomain\lowell have SELECT permissions on HR.dbo.Payroll?

did you find any script that was close...

sqlbuddy123 (4/3/2014)

---

Is it possible to run index reorg & update stats on nightly basis and rebuilds during the weekend...

Our maintenance are scheduled to run every sunday around 5 AM

Thanks

We are using EMC VMAX storage. Also, i can high index fragmentation on some indexes...do you think that would be one of the cause ?

Thanks Keith...

I looked at the IO subsystem and its suspicious....i have queried using sys.dm_io_virtual_file_stats and i can see avg. disk ms/read is high on D drive > 28.

Please let me...

Thanks Bhuvnesh...i tried all scripts, error log and windows log ..no errors were reported.

I just got a response from SA's saying that this issue might be related to opening files,...

Thanks bhuvnesh...very informative..on looking at the task manager again...I can see a NonPaged memory helding almost 8.5 GB.( Under Kernel memory left bottom of performance tab of task manager )

Did...

Thanks Dan..I have already checked the show process tab.

Thanks Bhuvnesh.

I'm aware of this, i tried couple of DMV's and DBCC memorystatus commands as well. but i'm not sure where to start and how to decide where the issue...

Keith Tate (10/7/2013)

---

Do you use a scheduled job to refresh the test database? If so, then add a step to run your script. If you don't use a scheduled job...

Thanks Jack...

i found this website which is exactly...

Jack Corbett (9/16/2013)

---

You can create a server group in SSMS (Registered Servers tab), right-click on the group and select new query. Then the query will be run...

Thanks a lot bob.

Thanks Bob for the response. i'm able to see the result....can i see all the startup parameters using this script ?

with this script...

SELECT value_name,value_data FROM sys.dm_server_registry

i'm able to...