Tuesday, June 4, 2013

[MS SQL Server] SQL Server and Oracle on same SAN

[MS SQL Server] SQL Server and Oracle on same SAN

SQL Server and Oracle on same SAN

Posted: 04 Jun 2013 05:13 AM PDT

HiWe have a NetAPP iSCSI SAN, with 120 disks, we already have made some aggregates for Oracle, and now we have some extra capasity on our iSCSI SAN.We want to use this for SQL Server installationsIs there a problem with io patterns, causing in performance degrade?We have apporx 1mio transactions pr min, or 35 GB in one hour. We have talked about moving our Sharepoint server..My major concern is performance, and if any issues are known, I would like to know them, now in front, and not when we have a problem

Batch Request/Sec Bottleneck? How do you know?

Posted: 04 Jun 2013 01:35 AM PDT

Hello all, I have been reading about batch requests/sec as a stat for measuring performance but what I fail to find is a way to determine what is a good level of Batch requests/sec. Can someone point out what it can be compared against or is there a general number that indicates a bottleneck?For instance if cpu utilization is pinned at 90% it is an indicator of a bottleneck. If batch requests/sec is at 2,000 during peak is that good or bad?

SQL Error Log AWE not enabled

Posted: 03 Jun 2013 09:13 PM PDT

Spotted this in SQL ERROR log"SQL Server is not configured to use all of the available system memory. To enable SQL Server to use more memory, set the awe enabled option to 1 by using the sp_configure stored procedure."So off I wentsp_configure 'min server memory', 1024RECONFIGUREGOsp_configure 'max server memory', 3072RECONFIGUREGOConfiguration option 'min server memory (MB)' changed from 0 to 1024. Run the RECONFIGURE statement to install.Configuration option 'max server memory (MB)' changed from 2147483647 to 3072. Run the RECONFIGURE statement to install.Did I do the right thing? Its only a laptop with 4GB of memory! Why was i set at 2147483647 ? I think I have seen 2147483647 as the MAX memory before.Am I ngoing bonkers or is this some kind of forgot to convert to MB kind of issue?CheersE

Previously registered servers awol

Posted: 03 Jun 2013 08:15 PM PDT

Hi all,Wondered if anyone could assist?I've logged on to one of my SQL Server 2008 R2 instances and have received the following message:TITLE: Registered Servers------------------------------Unable to read the list of previously registered servers on this system. Re-register your servers in the 'Registered Servers' window.------------------------------ADDITIONAL INFORMATION:Serialization output is invalid. (Microsoft.SqlServer.Management.Sdk.Sfc)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.5500.0+((Katmai_PCU_Main).110922-0336+)&LinkId=20476------------------------------'None' is an invalid XmlNodeType. Line 7, position 9. (System.Xml)The 'help' link in the additional information directs to another message basically saying there's no additional information available! so I had a look at BOL and could only find one reference to this issue but it's to do with upgrading from SQL 2005. My instance has been running 2008 for easily 2-3 years now!! The instructions ([url]http://support.microsoft.com/kb/955648[/url]) advise to open SSMS, open registered servers window, expand the Database Engine node, R/Click Local Server Groups, point to tasks and click Previously Registered Servers..... this would be great but my instance isn't displaying anything under any of the nodes (Database Engine, Analysis Services, Reporting Services etc etc).I can still view the DB's in object explorer but can't query any of the databases using T-SQL (even system stored procedures!), I get the following error:- 'An error occurred while executing batch. Error message is: The directory name is invalid.' Can anyone suggest anything please as I'm royally stumped.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog