Viewing 15 posts - 6,091 through 6,105 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 24, 2015 at 2:48 am
SQL Guy 1 (4/23/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 23, 2015 at 4:25 am
A sysadmin has all rights in all databases and cannot be denied any permissions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 23, 2015 at 4:09 am
gautamraj50 44895 (4/22/2015)
ALTER DATABASE database_Name
SET EMERGENCY;
Go
ALTER DATABASE Database_Name
SET...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 23, 2015 at 2:24 am
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 23, 2015 at 2:16 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 22, 2015 at 4:19 am
Viewing 15 posts - 6,091 through 6,105 (of 49,552 total)