.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Does HP storage pooling and/or EMC virtual provisioning technology work well for SQL Server?

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :Sql Server
 

We are looking to implement a new SAN, either an EMC CX400 or an HP EVA 6400.  In either case we are considering a storage pool technology.  EMC calls it virtual provisioning and I believe HP calls it storage pooling.  Essentially you have one or two large pools of drives and from there your SQL Server installations are presented logical chunks of disk.  It's even possible to have multiple arrays on the same drives.  In HPs proposal we will have a pool of (58) 146GB drives.  We can then present them to SQL Server as one drive letter or multiple drive letters. 

We are still trying to understand how this technology works.  It clashes with the old practice of keeping your logs, data and tempdb on separate arrays in order to minimize seek time.

We would love to hear from people who are using this technology.  How well does it work for you?  How big is your storage pool and did you carve it up into logical drive letters?  Do you still use Perfmon to monitor disk performance?  What problems does this present?

Thanks,   Dave




View Complete Post


More Related Resource Links

Remote Blob Storage - does SQL Server do all the work?

  
Hi folks, I hope this is the right forum to ask this question - I couldn't find any specific SQL forums to post this so here goes... We are hoping to use Remote Blob Storage (RBS) and are running some tests to check suitability. When I first read the documentation I had assumed that RBS was something you install, configure, and it "just works" i.e. the client applications write to SQL, and SQL takes care of moving the files on via RBS. But after implementing a test following the sample code it looks like the application/client still needs to be RBS-aware and has to stream data into/out of SQL via an RBS client provider. Am I missing something here? I had hoped that existing client applications would not have to change their logic i.e. they could continue to access SQL Server in exactly the same way, but would benefit by RBS moving blobs from binary/image fields to RBS-enable provider storage. But all the samples point to the clients having to use .NET libraries to interact with the RBS functionality, and while SQL then takes care of the rest it would mean any client would have to be modified to support this. If that's the case, I don't see the point to RBS. Yes, it's fantastic that we can store blobs outside of SQL via a common API, and yes, it is transaction-aware so blob clean-up is a much better experience, but the client has to still do the work to enable t

Remote Blob Storage - does SQL Server do all the work?

  
Hi folks, I hope this is the right forum to ask this question - I couldn't find any specific SQL forums to post this so here goes... We are hoping to use Remote Blob Storage (RBS) and are running some tests to check suitability. When I first read the documentation I had assumed that RBS was something you install, configure, and it "just works" i.e. the client applications write to SQL, and SQL takes care of moving the files on via RBS. But after implementing a test following the sample code it looks like the application/client still needs to be RBS-aware and has to stream data into/out of SQL via an RBS client provider. Am I missing something here? I had hoped that existing client applications would not have to change their logic i.e. they could continue to access SQL Server in exactly the same way, but would benefit by RBS moving blobs from binary/image fields to RBS-enable provider storage. But all the samples point to the clients having to use .NET libraries to interact with the RBS functionality, and while SQL then takes care of the rest it would mean any client would have to be modified to support this. If that's the case, I don't see the point to RBS. Yes, it's fantastic that we can store blobs outside of SQL via a common API, and yes, it is transaction-aware so blob clean-up is a much better experience, but the client has to still do the work to enable t

Test Run: Configuration Testing With Virtual Server, Part 2

  

Because Virtual Server is built upon a set of COM modules, you can automate the creation and testing of virtual machines. Here we use Windows PowerShell to run the tests.

Dr. James McCaffrey and Paul Despe

MSDN Magazine December 2008


Test Run: Configuration Testing With Virtual Server, Part 1

  

This time James McCaffrey sets up a virtual environment to use for configuration testing to introduce you to software configuration testing with Microsoft Virtual Server

Dr. James McCaffrey

MSDN Magazine September 2008


Virtual Server 2005: Program Customized Testing Environments Without Trashing Your Machine

  

Efficient testing can require many different machine and server configurations but the effort needed to manage these test environments can take a toll. Microsoft Virtual Server 2005 simplifies the provisioning and management of testing environments. This article demonstrates how the extensive Virtual Server COM API can be used to create an automated application testing environment to make your testing chores a whole lot easier.

Ben Waldron

MSDN Magazine August 2004


Connection Pooling To SQL Server

  
Hi Folks,

I'm a new SQL PFE and just encountered my first SharePoint installation at a customer site. (The first of many, I'm sure.) I ran some health checks on the SQL Server and noticed 600-700 user connections from the SharePoint account. The SharePoint admins and developers are novice to junior-level, and unfamiliar with connection pooling. I've never worked with SharePoint before and don't know what it's normal behavior is or how connections should be managed by SharePoint.

They indicated the SharePoint system is relatively new and only getting a small amount of use compared to what is expected soon.

SQL Server is handling the load well right now, but if the number of connections grows proportionally to the load, this will become a performance constraint.

1. Is this a normal number of connections for SharePoint?
2. If not, where can the SharePoint staff and myself find a thorough explanation of the principles of SharePoint connection pooling?

Thanks, JDL

AsyncPostBackTrigger doesn't work on server..

  

Hi, 
 I am new to asp.net and ajax. I have a problem while using update panel.
I have a tabcontainer with 3-4 tab panels. Inside one tab panel there is a cancel button. What i want to do is to when i hit cancel button in code behind i change active tab index to 0 so that tabcontainer shows first tab panel. I have update panel around tab container. This works at my localhost. But on server its behavior is very random. Sometimes it works sometime it doesn't. Unfortunately I am not able to debug it also. I don't know how to debug code on server. As on localhost it works correctly so I am kind of stuck. 

Server-side validation on an Entity Framework required field (property) does not work!

  
Has anyone had issues getting server-side validation on an Entity Framework required field (property) to work? The data type is a string (nvarchar). Server-side validation for required fields of other data types WORK fine. Only string fields have issues. I get the following error on UpdateModel(obj); of my POST method within the controller. Exception Details: System.Data.ConstraintException: This property cannot be set to a  null value.Source Error: Line 4500:                OnTextChanging(value);Line 4501:                ReportPropertyChanging("Text");Line 4502:                _Text = StructuralObject.SetValidValue(value, false);Line 4503:                ReportPropertyChanged("Text");Line 4504:                OnTextChanged(); I've even tried data annotations like this but it seems to get ignored.     [MetadataType(typeof(ObjMD))]     public partial class Obj     {    

Does SQL 2005 Enterprise Edition come preloaded on Windows Server 2003 Virtual Server.

  
Does SQL 2005 Enterprise Edition come preloaded on  Windows Server 2003 Virtual Server. I found this link http://www.microsoft.com/downloads/details.aspx?FamilyID=77f24c9d-b4b8-4f73-99e3-c66f80e415b6&displaylang=enMr Shaw

SQL Server and MapPoint: Making MapPoint 2010 and SQL Server Spatial Work Together

  
While SQL Server is a good repository for geospatial data, it doesn't communicate with MapPoint as well as it could. So our geo-data experts show you how to read point and polygon objects from SQL Server and render them in MapPoint and how to write points and polygons back to SQL Server using Entity Framework 4.0 included with Visual Studio 2010.Eric Frost, Richard MarsdenMSDN Magazine September 2010

Location Error on Install on Virtual Server - SQL Server 2008 R2

  
I'm trying to install SQL Server 2008 R2 on a Xen Server running Server 2008 R2. I get the following error.   The disc has been used to successfully install on other machines in my office. The virtual machine location settings are also all United States English. Any thoughts?

System.Diagnostics.Process.Start not work with IIS, but on ASP.NET Development Server

  
System.Diagnostics.Process.Start not work with IIS, but on ASP.NET Development Server 

Configure Sharepoint For File server Technology

  
hi . I want to use sharepoint as movie and picture Archive . Sharepoint Save all data in SQL Server DB . But this not good for my System because My movie file is so larg and so much . I want Save Pic and Movie in File server . please guide me . if any one have a good idea to implement this project , I get Happy to guide me . thanks .  

Does the "F5 experience" work with a multi-server 2010 farm?

  
I have a multi-server SharePoint 2010 farm I'm attempting to develop against.  I have Visual Studio 2010 installed on one of the servers.  When I create a default Visual Web Part project and hit F5, I get an error such as the following:   "Error 1 Error occurred in deployment step 'Activate Features': Feature with Id '06789185-b4a0-41d8-a535-1d8602a05b97' is not installed in this farm, and cannot be added to this scope."   After a bit of searching, I came across a thread that suggested multi-server farms were not supported by Visual Studio 2010 in regards to the F5 experience of being able to deploy, activate, and debug a feature.  Can anyone shed light on this for me?Chris Stewart

RequiredFieldValidtor does not work when embed inside server control

  
Hi, Do any one have any idea how to implement requiredfieldvalidtor. Server control which i have created does not work on client side. No javascript is been rendered and onSubmit the page.isvalid  returns true.  protected override void OnPreRender(EventArgs e) { PlaceHolder TextBoxPlaceHolder1 = null; PlaceHolder TextBoxPlaceHolder2 = null; PlaceHolder TextBoxPlaceHolder3 = null; WebControl InputControl = null; RequiredFieldValidator RequireValidator = null; Image Img = null; if ((this.FindControl(_TextBoxControl) == null) && (_TextboxPlaceHolder == null)) { Img = new Image(); _TextboxPlaceHolder = new PlaceHolder(); _TextboxPlaceHolder.ID = _TextBoxControl; if (_HasChildControl == false) { TextBoxPlaceHolder1 = new PlaceHolder(); TextBoxPlaceHolder1.ID = "LeftPanel"; TextBoxPlaceHolder2 = new PlaceHolder(); TextBoxPlaceHolder2.ID = "CenterPanel"; TextBoxPlaceHolder3 = new PlaceHolder(); TextBoxPlaceHolder3.ID = "RightPanel"; TextBoxPlaceHolder1.Controls.Add(_Label.GetControl());

Modal Popup Extender server side Show() does not work

  

Hello. Im using a modal popup extender to tell my user that the page has successfully been updated and then redirect them to a new page with the ok button. The thing is that i do NOT want this extender to fire when i press the button. I would rather call the Show() function myself. Right now i have a simple test page with a button that calls the popup extender Show() function but Nothing happens. If i set the targetID to the button it works but Im not able to call it through codebehind.

Any thoughts?

<%@ Page Title="" Language="C#" MasterPageFile="Master.master"

New SQL server 2008 connectioin will not work using hostname

  

We are trying to create an ODBC connection from a terminal server running server 2008 to a SQL server 2008 (also on a server 2008). When creating the connection from a server 2003 terminal server the connection is successful and i am able to gain access to my databases. However, when trying to create the same connection from the server 2008 terminal server we get an error that the server does not exist or access is denied. We have gotten the connection to work on the server 2008 terminal server but only if we use the FQDN or the IP address. We need to be able to use the hostname to make the connection easier for users who are making connections to the SQL server using access or excel.  WE have exhausted our efforts to correct this problem. We have checked DNS records and created a service principal name (SPN) in active directory. Thank you in advance for your help in resolving this issue.


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend