Friday, March 22, 2013

[MS SQL Server] Implementing RBAC

[MS SQL Server] Implementing RBAC

Implementing RBAC

Posted: 22 Mar 2013 02:57 AM PDT

All,We are implementing RBAC(Role Based Access Control)....and I have to create number of customized DB roles with permission in all the instances/databases. Anyone have suggestions/script to accomplish this? Please advise.Thanks,SueTons.

Very High CPU Usage by CHECKDB

Posted: 22 Mar 2013 01:14 AM PDT

We just build new 2 node active passive cluster windows 2008 R2. SQL 2008 R2 Enterprise edition on 64 CPU and 128 GB RAM. Database migration under testing now. No one else is using this server. Now when I run DBCC CHECKDB on a 20GB db, CPU spikes to 70-80 constantly. No other processes are running at all. As soon as I cancel dbcc command, CPU comes down to 0. Also when I run the same on existing PROD servers (with many other processes running) it doesnt affect CPU performance. I know dbcc checkdb is an resource intensive operation but nothing else running at all, why is it taking too much CPU. Any idea?

SQL SERVER : CPU

Posted: 21 Mar 2013 10:18 PM PDT

Hi , Someone can help me : I want a script that return me the consummation of CPU for last week (last 7 days ) :ermm: .

SQL Memory usage suddenly very high - Causing Cluster Failovers

Posted: 21 Mar 2013 08:32 PM PDT

We've noticed that memory usage on the DB cluster had suddenly changed. Normally PLE is fairly stable staying at around 6000 seconds. In the afternoon the PLE suddenly dropped from 6000 to under 300 and bounced between 0 & 600 averaging 300 for the rest of the day. At 6:11pm the cluster failed over, again at 00:12 and latest failover at 6:17am this morning. After the last failover, the PLE and memory usage went back till normal until approx 8:07am when the PLE suddenly went to 0 and SQL memory usage jumped up by approx 4GBIn the SQL Error log before each cluster failover we get these messages:03/21/2013 18:00:13,spid27s,Unknown,AppDomain 796 (mssqlsystemresource.sys[runtime].1143) unloaded.03/21/2013 18:00:13,spid1s,Unknown,AppDomain 796 (mssqlsystemresource.sys[runtime].1143) is marked for unload due to memory pressure.then03/21/2013 18:11:53,Logon,Unknown,Error: 18451<c/> Severity: 14<c/> State: 1.03/21/2013 18:11:52,Logon,Unknown,Login failed for user 'swconsumer'. Only administrators may connect at this time. [CLIENT: 10.0.100.38]03/21/2013 18:11:52,Logon,Unknown,Error: 18451<c/> Severity: 14<c/> State: 1.03/21/2013 18:11:52,Logon,Unknown,Login failed for user 'swbroker'. Only administrators may connect at this time. [CLIENT: 10.0.200.31]03/21/2013 18:11:52,Logon,Unknown,Error: 18451<c/> Severity: 14<c/> State: 1.03/21/2013 18:11:52,Logon,Unknown,Login failed for user 'swapi'. Only administrators may connect at this time. [CLIENT: 10.0.200.27]03/21/2013 18:11:52,Logon,Unknown,Error: 18451<c/> Severity: 14<c/> State: 1.03/21/2013 18:11:52,spid327,Unknown,The client was unable to reuse a session with SPID 327<c/> which had been reset for connection pooling. The failure ID is 23. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message.at which point SQL Shuts down and causes a cluster fail-overWe had a software release yesterday, so I assume that a change from that is causing these issues. Question is, where do I start looking to find the cause of this? Any help would be much appreciatedAndrew

Customized profiler trace stops running

Posted: 21 Mar 2013 05:51 AM PDT

Hello,I have a question regarding a profiler trace which suddenly stops after a while. Are there any known issues in 2008 or 2005 when creating a customized profiler trace via the command line ( not gui ) that it just haltsafte a certain amount of time ?i.e EXEC sp_trace_setstatus 2, 1GODECLARE @on BITSELECT @on = 1exec sp_trace_setevent 2, 14, 6, @onexec sp_trace_setevent 2, 14, 7, @onexec sp_trace_setevent 2, 14, 8, @onexec sp_trace_setevent 2, 14, 9, @onexec sp_trace_setevent 2, 14, 10, @on............ty

Audit Logout / Audit Login - Pooled Connection

Posted: 21 Mar 2013 10:53 PM PDT

I am experiencing intermittent connection drop outs on one of our applications which connects to our production database server.I have been profiling the instance to check the connections and i've noticed something odd with regards the audit login and audit logout events.Sometimes, the audit login uses a non-pooled connection but the associated logout event shows a pooled connection. Sometimes, the opposite occurs. The login uses a pooled connection and the associated logout shows a non-pooled connection.The majority are both pooled but every now and again the above scenario occurs.How is this possible?

Memory planning for sql server instances

Posted: 21 Mar 2013 04:52 PM PDT

Hello guys,Is there any standard calculation for the allocation of sql server maximum memory on sql server instances? So lets assume there is an instance A with a database of 500GB and an instance B with 2 databases of 250GB how do I use a standard method of allocating memory to these instances.Thank you
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog