SQL Server 2000 performance issues
Running SQL Server 2000, SP4 on Windows Server 2003 R2. 4GB RAM; 3GHz dual-processor, dual-core. The databases and logs are on an ISCSI SAN. This is the original implementation design. Since the beginning the users have said the system does not perform as well as they would like. The database application is a manufacturing information [...]
Answer Question
| February 16, 2009 7:05 PM
iSCSI, perfmon, SAN, SQL Server 2000, SQL Server performance, SQL Server performance tuning
Running SQL Server 2000, SP4 on Windows Server 2003 R2. 4GB RAM; 3GHz dual-processor, dual-core. The databases and logs are on an ISCSI SAN. This is the original implementation design. Since the beginning the users have said the system does not perform as well as they would like. The database application is a manufacturing information [...]
Answer Question
| February 16, 2009 7:05 PM
iSCSI, perfmon, SAN, SQL Server 2000, SQL Server performance, SQL Server performance tuning
Measuring SAN IOPS
How can I measure IOPS between the SAN and VMware ESX server, Windows server, AIX, SUN, HPUX and Linux?
Answer Question
| February 11, 2009 3:39 PM
IOPS, SAN, SAN Performance, Server Performance, VMware
How can I measure IOPS between the SAN and VMware ESX server, Windows server, AIX, SUN, HPUX and Linux?
Answer Question
| February 11, 2009 3:39 PM
IOPS, SAN, SAN Performance, Server Performance, VMware
Looking for multi-vendor Storage Virtualization
Need a “simple concept” to do the SAN Interconnect based Storage virtualization on multi vendor basis / heterogeneous SAN sub system based. And how much this will be helpful on ROI? -Guru
Answer Question
| February 9, 2009 9:47 AM
Network storage, NFS, SAN, Shared Network Storage, Storage ROI, Storage virtualization, Virtualization ROI/TCO
Need a “simple concept” to do the SAN Interconnect based Storage virtualization on multi vendor basis / heterogeneous SAN sub system based. And how much this will be helpful on ROI? -Guru
Answer Question
| February 9, 2009 9:47 AM
Network storage, NFS, SAN, Shared Network Storage, Storage ROI, Storage virtualization, Virtualization ROI/TCO
Throughput calculator for all the SAN subsystem?
I was searching for a long time for a simple tool which can tell us the controller throughput of any SAN environment. Its necessary for every Storage engineer to have this utility to cross verify the subsystem we buy. Ofcourse the vendor will have the tool or LAB benchmark for the same. But those will [...]
Answer Question
| August 20, 2009 9:43 AM
Bandwidth, Fibre channel, Network storage, NFS, SAN, SAN throughput, SAN throughput sizing, Shared Network Storage, Storage Area Network, Throughput
I was searching for a long time for a simple tool which can tell us the controller throughput of any SAN environment. Its necessary for every Storage engineer to have this utility to cross verify the subsystem we buy. Ofcourse the vendor will have the tool or LAB benchmark for the same. But those will [...]
Answer Question
| August 20, 2009 9:43 AM
Bandwidth, Fibre channel, Network storage, NFS, SAN, SAN throughput, SAN throughput sizing, Shared Network Storage, Storage Area Network, Throughput
Any common tool for measuring controller throughput?
I was searching for a long time for a simple tool which can tell us the controller throughput of any SAN environment. Its necessary for every Storage engineer to have this utility to cross verify the subsystem we buy. Ofcourse the vendor will have the tool or LAB benchmark for the same. But those will [...]
Answer Question
| February 6, 2009 9:41 AM
Fibre channel, NAS, Network Controller, SAN, SAN throughput sizing, Storage management
I was searching for a long time for a simple tool which can tell us the controller throughput of any SAN environment. Its necessary for every Storage engineer to have this utility to cross verify the subsystem we buy. Ofcourse the vendor will have the tool or LAB benchmark for the same. But those will [...]
Answer Question
| February 6, 2009 9:41 AM
Fibre channel, NAS, Network Controller, SAN, SAN throughput sizing, Storage management
EMC CX4 VS Netapp 3140 VS Lefthand SAN/iQ
I would like to know what SAN is best to implement ESX 3.5. In regards to features, management, and useable space. If anyone here went through the process of implementing any of these products why did you choose the one you have. If you’re using 2 of the 3 or maybe all, why do you [...]
Answer Question
| January 22, 2010 4:55 PM
EMC CX4, Lefthand SAN/iQ, Netapp 3140, SAN, VMware ESX 3.5, VMware ESX 3.5 Implementation
I would like to know what SAN is best to implement ESX 3.5. In regards to features, management, and useable space. If anyone here went through the process of implementing any of these products why did you choose the one you have. If you’re using 2 of the 3 or maybe all, why do you [...]
Answer Question
| January 22, 2010 4:55 PM
EMC CX4, Lefthand SAN/iQ, Netapp 3140, SAN, VMware ESX 3.5, VMware ESX 3.5 Implementation
How does one guarantee the integrity of snapshot done at block level
Hi, I have an equallogic SAN and I am looking at using the snapshot function for backup. My server are linux (redhat 4.0) with oracle database 10.2.0.3. What, if any, actions must I do to ensure that the snaphot made on the SAN (block level) is complete. In other word, does Linux have a cache [...]
Answer Question
| February 3, 2009 9:04 PM
Backup, EqualLogic, EqualLogic SAN, Red Hat Enterprise Linux, Red Hat Enterprise Linux 4.0, SAN
Hi, I have an equallogic SAN and I am looking at using the snapshot function for backup. My server are linux (redhat 4.0) with oracle database 10.2.0.3. What, if any, actions must I do to ensure that the snaphot made on the SAN (block level) is complete. In other word, does Linux have a cache [...]
Answer Question
| February 3, 2009 9:04 PM
Backup, EqualLogic, EqualLogic SAN, Red Hat Enterprise Linux, Red Hat Enterprise Linux 4.0, SAN
Does the log_file_name_convert parameter only rename the redo log files in a dataguard?
Hello I’ve installed a Oracle RAC 10gR2 with two nodes and using the dataguard in a single database. I’m using a different SAN to both environments (all the servers are linux). I’m using the physical mode for replications and using the OMF (I’m using the ASM to handle the storage with the OMF option). But [...]
Answer Question
| January 27, 2009 7:14 PM
ASM, Dataguard, OMF, Oracle RAC, Oracle RAC 10g R2, SAN
Hello I’ve installed a Oracle RAC 10gR2 with two nodes and using the dataguard in a single database. I’m using a different SAN to both environments (all the servers are linux). I’m using the physical mode for replications and using the OMF (I’m using the ASM to handle the storage with the OMF option). But [...]
Answer Question
| January 27, 2009 7:14 PM
ASM, Dataguard, OMF, Oracle RAC, Oracle RAC 10g R2, SAN
SAN questions – SAN array sizing
1. SAN: Can it support multiple concurrent accesses? 2. What are the trade-off’s between SAN array size and number of concurrent indexer processes (take note indexers will be constantly polling, renaming and deleting files) if i am creating an indexer? 3. SAN: Upon scaling are there any potential bottlenecks or limits?
Answer Question
| January 20, 2009 4:32 PM
Array, SAN, SAN management, SAN Scaling
1. SAN: Can it support multiple concurrent accesses? 2. What are the trade-off’s between SAN array size and number of concurrent indexer processes (take note indexers will be constantly polling, renaming and deleting files) if i am creating an indexer? 3. SAN: Upon scaling are there any potential bottlenecks or limits?
Answer Question
| January 20, 2009 4:32 PM
Array, SAN, SAN management, SAN Scaling
Trouble with SQL Server 2005 Upgrade Advisor when trying to detect an instance
I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when going to the pull-down menu, nor does it recognize it when I key in the instance name. We are [...]
Answer Question
| December 5, 2008 6:34 PM
SAN, SQL Server 2000, SQL Server 2005, SQL Server 2005 Upgrade Advisor, SQL Server Upgrade Advisor, Windows Cluster
I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when going to the pull-down menu, nor does it recognize it when I key in the instance name. We are [...]
Answer Question
| December 5, 2008 6:34 PM
SAN, SQL Server 2000, SQL Server 2005, SQL Server 2005 Upgrade Advisor, SQL Server Upgrade Advisor, Windows Cluster
SQL Server 2005 Upgrade Advisor in a cluster/SAN environment
I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when I go to the pull-down, nor does it recognize it when I key in the instance name. We are [...]
Answer Question
| December 4, 2008 3:22 PM
Cluster, DTS packages, SAN, SAN/CLuster Environment, SQL Server 2000, SQL Server 2005, SQL Server 2005 Upgrade Advisor, Windows Cluster
I installed the SQL Server 2005 Upgrade Advisor so I can analyze our SQL Server 2000 instance and DTS packages. Even though SQL Server 2000 is up and running, it does not recognize our instance when I go to the pull-down, nor does it recognize it when I key in the instance name. We are [...]
Answer Question
| December 4, 2008 3:22 PM
Cluster, DTS packages, SAN, SAN/CLuster Environment, SQL Server 2000, SQL Server 2005, SQL Server 2005 Upgrade Advisor, Windows Cluster
iSCSI Initiator not connecting to servers
Currently I have HP SAN environment setup using ISCSI. The servers within the SAN are connected straight to the network via Cat5 cable. The servers are connected to the array and Initiator via ISCSI. The issue I am having is the 3 servers I have connected to the initiator do not reconnect upon reboot. When [...]
Answer Question
| July 16, 2011 3:38 PM
Event ID 10, iSCSI, iSCSI Error, iSCSI Initiator, SAN
Currently I have HP SAN environment setup using ISCSI. The servers within the SAN are connected straight to the network via Cat5 cable. The servers are connected to the array and Initiator via ISCSI. The issue I am having is the 3 servers I have connected to the initiator do not reconnect upon reboot. When [...]
Answer Question
| July 16, 2011 3:38 PM
Event ID 10, iSCSI, iSCSI Error, iSCSI Initiator, SAN
FileMaker Pro v8 SAN Backup
We are running a mission critical application on Filemaker. The FileMaker server, a Dell Poweredge 2650, is configured to conducts scheduled backups 5x daily. However, the backups are saved on the server itself. We want to move the backups to the SAN and conduct the backups at non peak usage times. Does anyone have any [...]
Answer Question
| July 7, 2009 6:45 PM
Backup, Backup & recovery, Database Backup Strategies, Dell PowerEdge 2650, Filemaker Pro, FileMaker Pro 8, FileMaker Server, SAN, SAN Backup, Scheduled Backup
We are running a mission critical application on Filemaker. The FileMaker server, a Dell Poweredge 2650, is configured to conducts scheduled backups 5x daily. However, the backups are saved on the server itself. We want to move the backups to the SAN and conduct the backups at non peak usage times. Does anyone have any [...]
Answer Question
| July 7, 2009 6:45 PM
Backup, Backup & recovery, Database Backup Strategies, Dell PowerEdge 2650, Filemaker Pro, FileMaker Pro 8, FileMaker Server, SAN, SAN Backup, Scheduled Backup
Replicating SAN to DR Site
We are looking to build a warm DR site across town. How are other companies managing to duplicate their data in a reasonable time to another location? We are looking to copy around 150 GB per day. We don’t need up to the minute data, up to the hour or two is acceptable.
Answer Question
| December 1, 2008 4:21 PM
Data Replication, Disaster Recovery, Disaster recovery planning, DR, SAN, WAN
We are looking to build a warm DR site across town. How are other companies managing to duplicate their data in a reasonable time to another location? We are looking to copy around 150 GB per day. We don’t need up to the minute data, up to the hour or two is acceptable.
Answer Question
| December 1, 2008 4:21 PM
Data Replication, Disaster Recovery, Disaster recovery planning, DR, SAN, WAN
iSCSI SAN Server suggestions?
We are in the process of purchasing a new SAN server. I was curious if anyone has any good or bad experience with HP, Netapp, Dell, Fujitsu or others. We will be using Exchange 2007 mostly in the environment and need something that is very expandable. Thanks
Answer Question
| November 24, 2008 9:40 PM
Exchange 2007, iSCSI, iSCSI SAN Server, SAN, Storage management
We are in the process of purchasing a new SAN server. I was curious if anyone has any good or bad experience with HP, Netapp, Dell, Fujitsu or others. We will be using Exchange 2007 mostly in the environment and need something that is very expandable. Thanks
Answer Question
| November 24, 2008 9:40 PM
Exchange 2007, iSCSI, iSCSI SAN Server, SAN, Storage management
Need a checklist to audit a typical SAN to record all the components
We need a checklist to audit a typical SAN to record all the components of the SAN. The aim is also to record the metrics with view to help improve performance. Can you please help?
Answer Question
| August 30, 2009 6:55 PM
IT audit, SAN, SAN Auditing, SAN management, Storage performance
We need a checklist to audit a typical SAN to record all the components of the SAN. The aim is also to record the metrics with view to help improve performance. Can you please help?
Answer Question
| August 30, 2009 6:55 PM
IT audit, SAN, SAN Auditing, SAN management, Storage performance
Accessing heterogeneous disk arrays to a Windows server using a single HBA via SAN
I am planning my disk array upgrade, and I want to know if anyone has any thoughts, or if there are any reference/best practice/white papers, for accessing heterogeneous disk arrays to a Windows server using a single HBA via SAN. Any concern about the multi-path software?
Answer Question
| November 18, 2008 6:49 PM
Disk arrays, HBA, Heterogeneous disk arrays, SAN, Storage best practices, Storage hardware
I am planning my disk array upgrade, and I want to know if anyone has any thoughts, or if there are any reference/best practice/white papers, for accessing heterogeneous disk arrays to a Windows server using a single HBA via SAN. Any concern about the multi-path software?
Answer Question
| November 18, 2008 6:49 PM
Disk arrays, HBA, Heterogeneous disk arrays, SAN, Storage best practices, Storage hardware
iSCSI associations dissapear at reboot need to manually reconnect
I’ve got two SLES 10 x64 SP2 systems, and whenever i reboot, their iSCSI associations disappear. My disk array is a Dell MD3000i with 4 x iSCSI interfaces. I’ve done a normal discovery and explicitly toggled all of them to automatic startup but still need to manually reconnect Submitted by a User
Answer Question
| November 17, 2008 7:40 PM
Dell MD3000i, iSCSI, iSCSI Associations, iSCSI Interface, SAN
I’ve got two SLES 10 x64 SP2 systems, and whenever i reboot, their iSCSI associations disappear. My disk array is a Dell MD3000i with 4 x iSCSI interfaces. I’ve done a normal discovery and explicitly toggled all of them to automatic startup but still need to manually reconnect Submitted by a User
Answer Question
| November 17, 2008 7:40 PM
Dell MD3000i, iSCSI, iSCSI Associations, iSCSI Interface, SAN
Urgent SAN on Redhat x86_64 problem
If I run probe-luns -a, it shows all 3 luns. I then use fdisk -l and it shows the devices as expected. Output after reboot: [root@hhln-mgt-sac101 ~]# fdisk -l Disk /dev/cciss/c0d0: 146.7 GB, 146778685440 bytes 255 heads, 63 sectors/track, 17844 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End [...]
Answer Question
| November 4, 2008 12:47 PM
FDISK, HBA, Logical Unit Number, LUN, Probe LUNs, Redhat Linux, SAN, Storage Area Network, x86_64
If I run probe-luns -a, it shows all 3 luns. I then use fdisk -l and it shows the devices as expected. Output after reboot: [root@hhln-mgt-sac101 ~]# fdisk -l Disk /dev/cciss/c0d0: 146.7 GB, 146778685440 bytes 255 heads, 63 sectors/track, 17844 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End [...]
Answer Question
| November 4, 2008 12:47 PM
FDISK, HBA, Logical Unit Number, LUN, Probe LUNs, Redhat Linux, SAN, Storage Area Network, x86_64
Shared SAN LUN between Win2K3R2 std Svrs
Is it possible to share an EMC symentrics LUN between two windows 2003 R2 std servers without having to use third party software like ms clustering? one write and the other read only…
Answer Question
| November 6, 2008 6:02 PM
EMC Symmetrix, LUN, SAN, SAN management, Windows Server 2003, Windows Server 2003 R2
Is it possible to share an EMC symentrics LUN between two windows 2003 R2 std servers without having to use third party software like ms clustering? one write and the other read only…
Answer Question
| November 6, 2008 6:02 PM
EMC Symmetrix, LUN, SAN, SAN management, Windows Server 2003, Windows Server 2003 R2
