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


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

SQL server storage RAID subsystem

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server
 

I had posted some questions on here about a month ago regarding problems with a clients SQL server.  I have spent the last month doing alot of research on the subject and after isolating the mdf, ldf, and tempdb files the SQL server is still showing IO waits that indicate that the IO system is not capable of maintaining the performance standards and average read write times well above 2ms ... Right now the mdf is on a two disk raid one and the ldf, tempdb are on separate (i know this is not a stable long term configuration for stability)

Original Post

Top waits are ...

SLEEP_BPOOL_FLUSH
WRITELOG
PAGEIOLATCH_SH
PAGEIOLATCH_EX
BACKUPBUFFER
ASYNC_IO_COMPLETION
ASYNC_NETWORK_IO
BACKUPIO
PREEMPTIVE_OS_WAITFORSINGLEOBJECT
IO_COMPLETION

I'm thinking about getting a 12-24 disk SATA or SAS raid array and card, the company is only going to grow and the IO pressure is not going to decrease.  The server is a dell power-edge 710.  I'm very interested if anyone can point me in the right direction with this purchase.  I'm trying to keep it under 7,000 but I would be able to break up the SQL files onto separate raids ... I was thinking about


View Complete Post


More Related Resource Links

SQL Server RAID 1 , 1+0 and TempDB

  
Hi, I am tuning a disk sub system for our OLTP datebase server these days. This is DAS disks. I now came into a question. The server has 8 148GB SAS drives. To have fault tolerance, we want to have RAID mirroring, so RAID 1 or 10. That leaves us half of the whole capacity, which is 4 * 148GB. As this box is only used for database, we want to have partitions for OS, data file, log file and temp db. Now I there is a dilemma: I know for best practise, temp db should on its own physical disk. If I set up four partition(logical drives), one for OS, one for data files, one for logs and one for temp db, then I can only have RAID 1 on each of the disk array. But the advantage of this is temp db is only its own disk. Or the second choice I can have is to partition the disks into three array (logical drives), namely OS, data files and logs. In this case I can have RAID 1+0 (striping and mirroring) on data file partition and RAID 1 on OS  and log. Could you give me some idea, which one is better? Any disscussions are welcome. Thank you very much.

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

SQL Server 2000, or SQL Server 2005 failover clusters on the 32-bit subsystem (WOW64)

  
Hi All I don't know what is WOW64,some where I read "SQL Server 2000, or SQL Server 2005 failover clusters on the 32-bit subsystem (WOW64)" In my environment SQL Server 2000 version is "Microsoft SQL Server  2000 - 8.00.2282 (Intel X86)   Dec 30 2008 02:22:41   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) " is it same ?? How find out my environment is WOW or NOT. Thanks in advance          SNIVAS

Does HP storage pooling and/or EMC virtual provisioning technology work well for 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


Error Message "Not enough server storage is available to process this command" thrown when using Dia

  

I've been trying to make a library that uses the System.Diagnostics.PerformanceCounters to monitor perfmon on a variety of machines in C#. While the system seems to run fine, I've noticed after three weeks or so of polling that I just started receiving the error:

"Not enough server storage is available to process this command" on Windows Server 2003 machines

which the stack trace identifies as being from:

at System.Diagnostics.PerformanceMonitor.GetData(String item)
   at System.Diagnostics.PerformanceCounterLib.GetPerformanceData(String item)
   at System.Diagnostics.PerformanceCounterLib.get_CategoryTable()
   at System.Diagnostics.PerformanceCounterLib.GetCategories()
   at System.Diagnostics.PerformanceCounterLib.GetCategories(String machineName)
   at System.Diagnostics.PerformanceCounterCategory.GetCategories(String machineName)

 

The same error occurs when I try hitting System.Diagnostics.Process.GetProcesses().

 

I can "fix" the issue by restarting the Remote Registry, but it's not really a long term solution since I won't be able to do this going forward on all of the machines.

 

I've noticed that on the machines that fail, around the time the failure occurs, I start to see warnings in the

send files from a server to a storage server on the same network

  

hi ,

i have a folder on the server which contains jpeg files,mp4 files and also xml files...........

i would like to transfer the folder to a centralised storage server ,i would like to pass the credentials from the web page itself,,,,,,,,

what do i use for it

the storage server is within the network and all it needs is credentials to copy the folder which i m ready to pass....but i dont know the code which has to be used......

whether to use system.io.move

or


httpwebrequest.


please help me

thank you


Installing & configuring Remote BLOB Storage (RBS) with the FILESTREAM provider (SharePoint Server 2

  

Hi,


I really do not know the reason, how much ever i tried; I am NOT getting message in "rbs_install_log.txt" like; “Product: SQL Remote Blob Storage -- Installation completed successfully.”


I can see Several tables residing under the content database with names that are preceded by the letters "mssqlrbs".

In Object Explorer, right-clicking  <DatabaseServer>, and then clicking Properties; In the Server Properties dialog box, clicking Advanced, clearly shows that the FilestreamAccess Level is set to Full access enabled

Right-clicking  the content database name, and then clicking Properties,
when I check the Database Properties dialog box by clicking Filegroups,
I see that,  in the Filestream list, RBSFilestreamProvider appears. Even under Files, in the Database files list, RBSFilestreamFile appears

------------------------------------------------------------------------------------------------

use [ContentDbName]







if not exists 

SQL Server 2008 R2 on Windows 2008R2 Ent - Drives+Raid Configuration + W2008 Disk Initialization

  

Hi, I just want to make sure that we setup this server the best way possible as we are moving from a previous box where

performance was affected mainly because of partitioning and SQL memory optimizations.

 

The Hardware:

Dell PowerEdge R710 

  • Intel® Xeon® X5660, 2.8Ghz, 12M Cache,Turbo, HT, 1333MHz
  • 64GB Memory (8x8GB), 1333MHz Dual Ranked RDIMMs
  • PERC H700 Controller
  • 8 x 300GB 10K RPM Serial-Attach SCSI 6Gbps 2.5in Hotplug Hard Drive
  • Virtual Volume 1: 2 Drives = Raid 1 - for the OS
  • Virtual Volume 2: 2 Drives = Raid 1 - for the ldf's
  • Virtual Volume 3: 4 Drives = Raid 10 - for the mdf's

Windows 2008R2 64bits is installed on Volume 1.

- I would like to know what suggestions you might have for the Initialization of the other 2 volumes (MBR or GPT).

- Any other settings like partition align = 64

- Memory Settings at the OS level.

- Memory Settings on SQL.

- Any other recommendations.


Installing & configuring Remote BLOB Storage (RBS) with the FILESTREAM provider (SharePoint Server 2

  

Hi,

Hi

Based on many blog posts / articles on Remote BLOB Storage with FileStream Provider,  I could easily do for one Web-Application. It is working fine too. But my Issue is, I have 3 Web-Applications in turn 3 Content Databases. Out of three, anyway 1st one went smooth since I followed all the steps. For the next two Content Databases, I am facing Issues like; When I tried;

use [WSS_Content_Blob_ca4557eec6434e8e9a7920dfba1e9a2c]
alter database [WSS_Content_Blob_ca4557eec6434e8e9a7920dfba1e9a2c] add file (name = RBSFilestreamFile, filename = 'c:\Blobstore') to filegroup RBSFilestreamProvider

It is giving;

Msg 5520, Level 16, State 2, Line 1
FILESTREAM file 'RBSFilestreamFile' cannot be added because its destination filegroup cannot have more than one file.

If I try with another Folder for example; c:\Blobstore_2ndWebApp

use [WSS_Content_Blob_ca4557eec6434e8e9a7920dfba1e9a2c]
alter database [WSS_Content_Blob_ca4557eec6434e8e9a7920dfba1e9a2c] add file (name = RBSFilestreamFile, filename = 'c:\Blobstore_2ndWebApp') to filegroup RBSFilestreamProvider

I get Command(s) completed successfully.

But when I run below piece of code with my values;


msiexec /qn /i

Event 18210 error - Operating system error 1130 (not enough server storage is available to process t

  

I tried for the last three days to do a restore over the network or copy the files from one server to another. I kept getting NOT Enough space but there is 500GB free for 49GB file.

OS: Windows Server 2008 64bits

SQL Server 2008 R2 Enterprise 64bits

Restoring using T-sql got the following error:

Msg 3203, Level 16, State 1, Line 1

Read on "\\servername\backup\xxxxx\xxxxx_backup.bak" failed: 1130(Not enough server storage is available to process this command.)

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

Event log as the following:

BackupIoRequest::ReportIoError: read failure on backup device '\\servername\backup\xxxxx\xxxxx_backup.bak'. Operating system error 1130(Not enough server storage is available to process this command.).

I did some research and I found stuff for SQL 7 or windows XP or NT old s

Sql Server Management Studio->Table Properties->Storage->Index Space

  

Hello Forum Members,

 I have a table with 10K rows which does not have any indexes.But when I select the table properties,click on storage I see index space has a value and is not null as i thought. Will sqlserver add deafult index space even if there are no indexes on the table?? Please advise.

 

Thanks


SQL Server 2008 R2 clustering with windows storage server 2008

  

Hello,

I want to implement a full redundant of SQL server for our client. My current topology is: 2 failover cluster of SQL server on 2 different physical servers, and 1 (HP 1000 series) with windows storage server 2008 connected to the SQL servers on SAN.

Now, i want to implement a full availability. I need to add another windows storage server 2008 (to prevent system down in case of crash of first windows storage). My question is, is this available and feasible? what are the requirements?? is there any scenario on the internet that help in implementing such solutions? and is it solid infrastructure that could provide 99.9% ?

Your help is highly appreciated..

Best Regards,


Storage system for SSIS packages(SQL Server , File System, SSIS package store)

  

Hello SSIS experts,

 

I just wanted to confirm the difference between SQL Server storage and SSIS Package store for packages. As seen from the BIDS, the SQL Server list packages from msdb(point to note is the folder MSDB is not visible here) and SSIS Package store(MSDB folder is visible) and the authentication is defaulted to Windows (disabled)  from both the file system and msdb?  Just wanted to know if there are any other differences to be noted or request to let me know if there are any corrections to be madein my views?


Happy to help! Thanks. Regards and good Wishes, Deepak.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.
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