Hi ,

I have installed Server 2012 R2 on IBM Server X3650 ( Type- 7979I2S).

From that i have created Two RAID 1 Arrays with Controller Card 8K-L.
Logical Drive 1 - 64 GB2 - RAID 1. SAS ( OS )
Logical Drive 2 - 1 TB2 SATA ( DATA )

Starting its works very smooth, but after some days RAID MANAGER software given a defunct drive error from any of the hard disk. I can re-insert the defunct drive and after that it's work OK.
Yesterday, 1TB Logical Drives going offline, and drive missing on server.
I have investigate the issue and after final step to force online the drive, take the backup of data and recreate RAID 1 for 1 TB*2 HDD.
I have no idea what is going wrong with this server.
I have updated the Server Raid 8K-L firmware to the latest version.
BIOS - 5.2-0 (17003)
Firmware - 5.2-0 (17003 )
Device Driver - 7.2-0 ( 30261 )
Also updated the BIOS Drivers also, detail - IBM - [CGE149AUS-1.19]-, 2/11/2011.

Can any one pl. suggest on this ?

HI ,

Currently setup sql server express edition 2012 R2 with O.S. installed 2008 r2 std.

I am aware about express edition database size limit is 10 GB, Constrained to a single CPU , and Maximum memory utilized by SQL Server Database Engine is 1GB .

As of now 8 GB of ram installed and customer wants to increase ram on server.

From SQL instance we have set the default allocation for memory like it's use maximum.

Sometime when work loads, memory utilization on server was 80-90% and its only used by SQL server. at that time slowness issue occurred.

So my question is if i am increase the ram on server that may be helpful on express edition. Performance will increase on server or not ?

Thanks,
Bhautik Shah

HI ,

if the instance taking Maximum memory utilized by SQL Server Database Engine is 1GB then why its utilized 6 to 7 gb on actual.