Viewing 15 posts - 6,091 through 6,105 (of 49,571 total)
WhiteLotus (4/23/2015)
I just wonder what about if I need to monitor for 3 days ( from Wed until Friday ) ?
Why do you need to?
In that article giving the example...
April 24, 2015 at 2:59 am
It's a service broker error. Do some reading on Service Broker architecture and security requirements, then trace through what you have any where the error's coming from.
April 24, 2015 at 2:48 am
SQL Guy 1 (4/23/2015)
April 23, 2015 at 2:05 pm
No. That shouldn't be necessary at all. Might be faster than killing a few thousand forgotten connections though.
April 23, 2015 at 8:45 am
Sounds like one or more applications aren't closing their connections and hence you're getting more and more and more. Maybe do some monitoring on connection open and close, track what...
April 23, 2015 at 8:18 am
Have two jobs, one scheduled for the start of the interval with a ALTER LOGIN ... DISABLE and the other for the end of the interval with an ALTER LOGIN...
April 23, 2015 at 8:12 am
You can give permissions at any level, if the person is removed from the sysadmin role, the other permissions granted define what he can do. Additionally, granted permissions are always...
April 23, 2015 at 4:25 am
A sysadmin has all rights in all databases and cannot be denied any permissions.
April 23, 2015 at 4:09 am
gautamraj50 44895 (4/22/2015)
ALTER DATABASE database_Name
SET EMERGENCY;
Go
ALTER DATABASE Database_Name
SET...
April 23, 2015 at 2:24 am
SQL Guy 1 (4/22/2015)
How to find particular queries/stored procedures that causing this?
Probably none.
SQL doesn't use the paging file. If you're looking for stuff that's causing hard page faults (which...
April 23, 2015 at 2:15 am
N.D (4/22/2015)
Why? You said multiple times that the patch waits were not in TempDB, so why are you adding files to TempDB?
Reasons beginning with the letter P ... :rolleyes:
?? Sorry,...
April 22, 2015 at 7:10 am
N.D (4/22/2015)
In sysdatabases the following are listedsnapshot_isolation_state_desc = ON
is_read_committed_snapshot_on = 1
This setting was recommended by the vendor
Ah, that would explain why you have a silly combination of settings. 🙂
Do you...
April 22, 2015 at 6:06 am
I did, see the second paragraph in my initial reply for index suggestions. Unfortunately if there's no room to change the requirements, there won't be that much optimisation that can...
April 22, 2015 at 6:03 am
SQL Injection is a security risk. I gave you the performance recommendations (not much the way it's written), but for the security you really, really need to read up for...
April 22, 2015 at 4:19 am
Viewing 15 posts - 6,091 through 6,105 (of 49,571 total)