Monday, July 22, 2013

[SQL 2012] What is the performance point at which it makes sense to get Enterprise instead of Standard

[SQL 2012] What is the performance point at which it makes sense to get Enterprise instead of Standard

What is the performance point at which it makes sense to get Enterprise instead of Standard

Posted: 22 Jul 2013 02:09 AM PDT

We are looking to build a SQL Server server. We are looking to get SQL 2012, but not sure which version to get. At this point, I think Standard is all we need, but to make sure we cover our bases, I need to know at what point does it make sense to get Enterprise. Is there a number of users or a database size, amount of usable memory or something else that would be a reasonable indicator that we should get Enterprise?

SQL Questions

Posted: 21 Jul 2013 10:29 PM PDT

Hello SQL Experts,In my current support environment I am reviewing all SOP and OLA's for the SQL.Below are the few questions which I am seeking for an expert advice.1) While failing over the cluster should we pause\suspend the database mirror?2) What should be the best practice while handling database mirror and log shipping while working on Production and DR scenarios.Please let me know if we have any links\ or already have the answers for above queries.Thanks in advance.Regards,Austin

Always on Secondry database backup plan & Recovering.

Posted: 08 Mar 2013 11:14 PM PST

Hi All,Can any one suggest me one good backup plan for Always on secondaries server... ?Currently i am planning to doOne Full copy only backup--- Every 24 hour :Every 30 min Log backup.I am looking for the solution for recovering the database using this backup strategy.

Linked Server from SQL 2012 to SQL 2000

Posted: 22 Jul 2013 01:24 AM PDT

Hi,Please help, I have encountered the error below while creating a linked server from SQL Server 2012 to connect to SQL Server 2000.See error details below:cannot initialize the data source object of OLE db provider "SQLNCLI10" for linked server "db\instance"ole db provider "SQLNCLI10" for linked server "db\instance" returned message "login timeout expired",ole db provider "SQLNCLI10" for linked server "db\instance" returned message "A netrwork-related or instance-specific error has occured while establishing a connection tp SQL server. etc...Please suggest, thank you in advance.Thanks and Godbless,JosephS

Fail to open MDS Explorer

Posted: 21 Jul 2013 07:34 PM PDT

Hi! I try to install MDS but get stuck when opening the Explorer.It seems like a Silverlight and WCF communication problem but the message is unclear.[img]https://dl.dropboxusercontent.com/u/12915406/MDS/2013-07-22_error.gif[/img]I append my Environment, Log(IIS, MDS, Fiddler, UI) , and related config.Hope anyone could give me some advice. Thank you! :-)[b]Environment[/b]OS : Windows Server 2008 R2SQL : Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)[b]IIS7[/b]Silverlight (64 bit) 5.1.20513Browser : IE9 , FF22, Chrome 28MDS Server is installed on VM, in Windows Domain Login user has system administration permission.[b]Application Pools Setting[/b]MDS Application(a) Managed Pipeline Mode = Integrated(b) Identity = ApplicationPoolIdentity[b] My Settings[/b]Authentication :(a) MDS Website : Enable Windows Authentication. Disable Anonymous Authentication.Under Windows Authentication > Advanced Settings > set Extended Protection = Accept or Required(b) Service Folder : Enable Windows Authentication. Enable Anonymous Authentication.[b]My Web.Config[/b][url=https://dl.dropboxusercontent.com/u/12915406/MDS/web.config.txt.xml]https://dl.dropboxusercontent.com/u/12915406/MDS/web.config.txt.xml[/url][b]My applicationHost.config[/b][url=https://dl.dropboxusercontent.com/u/12915406/MDS/applicationHost.config.txt.xml] https://dl.dropboxusercontent.com/u/12915406/MDS/applicationHost.config.txt.xml [/url][b]UI Error Message[/b]When opening MDS Explorer, the UI popup error messages like this.[quote]WebException: [HttpWebRequest_WebException_RemoteServer] Arguments: NotFound Debugging resource strings are unavailable[/quote]If I use Firefox, more error messages show up.[quote]System.Reflection.TargetInvocationException: [Arg_TargetInvocationException][/quote][b]Fiddler Log[/b][img]https://dl.dropboxusercontent.com/u/12915406/MDS/2013-07-22_fid.gif[/img]green arrows point out the error request.Here is the full log [url=https://dl.dropboxusercontent.com/u/12915406/MDS/fiddler-log.html]https://dl.dropboxusercontent.com/u/12915406/MDS/fiddler-log.html[/url] .seems I don't have permission to access the request URL : http://mdsdev:88/Service/Service.svc/bhb[b]IIS Log[/b]bhb again, not sure how adjust to access it.[quote]2013-07-21 13:14:24 W3SVC2 fe80::208e:fa0c:31e5:901%10 GET /ScriptResource.axd d=jzBYvlgjGckxbHmd645HrUCsak8pPcTsujxzxXp5gfykwH0og-wOaIEfQRCkVtHUZaU9O-WZs75NSCtNmb4qyzx09zzgZlqq_Hxfv_GJZEA_V7wJtJkFpfiSaTBMqU17icKQwTLbTKf4fmtiRlbLYQ2&t=ffffffffb9f9f042 88 domainick fe80::208e:fa0c:31e5:901%10 HTTP/1.1 Mozilla/5.0+(Windows+NT+6.1;+WOW64;+rv:22.0)+Gecko/20100101+Firefox/22.0 mdsdev:88 200 0 0 12013-07-21 13:14:26 W3SVC2 fe80::208e:fa0c:31e5:901%10 GET /Explorer/AttributeSL.aspx MID=1&VID=1&EID=3 88 domainick fe80::208e:fa0c:31e5:901%10 HTTP/1.1 Mozilla/5.0+(Windows+NT+6.1;+WOW64;+rv:22.0)+Gecko/20100101+Firefox/22.0 mdsdev:88 200 0 0 3262013-07-21 13:14:27 W3SVC2 fe80::208e:fa0c:31e5:901%10 POST /Service/Service.svc/bhb - 88 domainick fe80::208e:fa0c:31e5:901%10 HTTP/1.1 Mozilla/5.0+(Windows+NT+6.1;+WOW64;+rv:22.0)+Gecko/20100101+Firefox/22.0 mdsdev:88 500 0 0 157[/quote][b]MDS Log[/b]First two rows mention error, few mention Unable to convert value of query string parameter Id = MID to an integer.[quote]MDS Error: 0 : Service started successfully, Assembly version: 11.0.0.0, file version: 11.0.2100.60 ((SQL11_RTM).120210-1917 ) DateTime=2013-07-21T13:26:55.2677163ZMDS Error: 0 : ApiContractVersion: 5102 DateTime=2013-07-21T13:26:55.2686929ZMDS Start: 1 : Service.InitializeExpirationStatusLine 2268: MDS Verbose: 0 : Unable to convert value of query string parameter Id = MID to an integerLine 2599: MDS Verbose: 0 : Unable to convert value of query string parameter Id = VID to an integer[/quote]
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog