Saturday, August 24, 2013

[SQL 2012] Capacity Planning

[SQL 2012] Capacity Planning

Capacity Planning

Posted: 23 Aug 2013 04:10 PM PDT

I'm sure many of you can answer this question, Usually for an existing system , Based on current metrics we could decided if need additional resources is required or not based on the usage of the system. My question, when we are developing new application, based on business requirements as below, how could we design a efficient capacity planning, For Ex:10000 Users 200 K transactions per day Database size is about 1 TBThroughput may be around 100MB/sec -Assumption OLTP VM or Physical I'm looking for what specs(Please exclude RAID Levels ) I can give to sysadmin and justify -Please post any tools or good documentation (Links) on this will helps

SQL server agent doesnt start

Posted: 23 Aug 2013 06:06 AM PDT

i AM TRYING TO START SQL SERVER AGENT BUT IT DOESNT START WITH ANY KIND OF ACCOUNT USED.any kind of help is appreciated

Surface Area Reduction

Posted: 23 Aug 2013 04:24 AM PDT

Check this Url for basic security settings:[url]http://www.itsecuritycenter.com/sql-server-security-by-surface-area-reduction.html[/url]
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog