9 More Discussions You Might Find Interesting
1. AIX
Hello,
All the commands on AIX are running very slow.
Below is few stats but I didn't find any issue in cpu or memory reosurces
vmstat
System configuration: lcpu=4 mem=6144MB ent=1.00
kthr memory page faults cpu
----- -----------... (2 Replies)
Discussion started by: Vishal_dba
2 Replies
2. Infrastructure Monitoring
There is a big problem with the server (VPS based on OpenVZ, CentOS 5, 3GB RAM). The problem is the following. The first 15-20 minutes after starting the server is operating normally, the load average is less than or about 1.0, but then begins to increase sharply% wa, then hovers around 95-99%.... (2 Replies)
Discussion started by: draiphod
2 Replies
3. Solaris
I recently configured a WANBoot server on a Ldom 2.0 running Solaris10u9 with ZFS root. When i start the installation form the client with
Ok Boot net - install ,
it takes at least 20-25 minutes just to download the miniroot on the client .. i read there was a bug on T servers firmware... (2 Replies)
Discussion started by: fugitive
2 Replies
4. Shell Programming and Scripting
HI All,
I am trying to automate my stuff to make 'to-do-easier'.
I am new to shell scripting. I need help to you regarding the below problem.
I have one directory in my server, frequently files will store in that directory. I want to move that files into another server on every 5... (5 Replies)
Discussion started by: ravvamohan
5 Replies
5. UNIX for Dummies Questions & Answers
Hi guyes our linux server is very slow today and load average is more than 16 .I m new in linux request you to kindly help resolving the issue.
Where can i find the log for the cause.
# lsb_release -a
LSB Version: ... (2 Replies)
Discussion started by: pinga123
2 Replies
6. UNIX for Dummies Questions & Answers
Hi,
Following my last post I've mounted the remote server on my local server. However copying files from this mounted server is increadbily slow. If I copy files using rcp it's very fast so I assume there must be a setting somewhere?
Any help appreicated.
Thanks (2 Replies)
Discussion started by: AngryBunny
2 Replies
7. UNIX for Advanced & Expert Users
Hello,
I am using Redhat redhat 4 update 4 kernal 2.6. My server is some time suddenly running slow.
The averge cpu load goes up to 50 to 60. (There is only two CPU and usually, the averge load
is between 1 to 2.5) That time, i see, there are several sessions connected.
Normally, we have... (5 Replies)
Discussion started by: govindts
5 Replies
8. HP-UX
Hi,
Since last week our server become too slow when we try to run application on it. When we run top command, it show as below:
So it's nothing to do with heavy utilization, right? Can you give some opinion on what actually had happended?
Thank you very much... :b: (4 Replies)
Discussion started by: yeazas
4 Replies
9. SCO
Hi,
Wonder is someone can help.
I've got a server SCO_SV 3.2v5.0.7 PentIII that is located at a different site and is running slow and has been for a week. I've been speaking to a third party who say nothing is wrong with it but its still running slow.
The 3rd party advise it could be a... (2 Replies)
Discussion started by: tez
2 Replies
PDO_SQLSRV-DSN(3) 1 PDO_SQLSRV-DSN(3)
PDO_SQLSRV DSN - Connecting to MS SQL Server and SQL Azure databases
The PDO_SQLSRV Data Source Name (DSN) is composed of the following elements:
o DSN prefix
- The DSN prefix is sqlsrv:.
o APP - The application name used in tracing.
o ConnectionPooling - Specifies whether the connection is assigned from a connection pool (1 or TRUE) or not (0 or FALSE).
o Database - The name of the database.
o Encrypt - Specifies whether the communication with SQL Server is encrypted (1 or TRUE) or unencrypted (0 or FALSE).
o Failover_Partner - Specifies the server and instance of the database's mirror (if enabled and configured) to use when the primary
server is unavailable.
o LoginTimeout - Specifies the number of seconds to wait before failing the connection attempt.
o MultipleActiveResultSets - Disables or explicitly enables support for multiple active Result sets (MARS).
o QuotedId - Specifies whether to use SQL-92 rules for quoted identifiers (1 or TRUE) or to use legacy Transact-SQL rules (0 or
false).
o Server - The name of the database server.
o TraceFile - Specifies the path for the file used for trace data.
o TraceOn - Specifies whether ODBC tracing is enabled (1 or TRUE) or disabled (0 or FALSE) for the connection being established.
o TransactionIsolation - Specifies the transaction isolation level. The accepted values for this option are PDO::SQL-
SRV_TXN_READ_UNCOMMITTED, PDO::SQLSRV_TXN_READ_COMMITTED, PDO::SQLSRV_TXN_REPEATABLE_READ, PDO::SQLSRV_TXN_SNAPSHOT, and PDO::SQL-
SRV_TXN_SERIALIZABLE.
o TrustServerCertificate - Specifies whether the client should trust (1 or TRUE) or reject (0 or FALSE) a self-signed server cer-
tificate.
o WSID - Specifies the name of the computer for tracing.
Example #1
PDO_SQLSRV DSN examples
The following example shows how to connecto to a specified MS SQL Server database:
$c = new PDO("sqlsrv:Server=localhost;Database=testdb", "UserName", "Password");
The following example shows how to connect to a MS SQL Server database on a specified port:
$c = new PDO("sqlsrv:Server=localhost,1521;Database=testdb", "UserName", "Password");
The following example shows how to connecto to a SQL Azure database with server ID 12345abcde. Note that when you connect to SQL
Azure with PDO, your username will be UserName@12345abcde (UserName@ServerId).
$c = new PDO("sqlsrv:Server=12345abcde.database.windows.net;Database=testdb", "UserName@12345abcde", "Password");
PHP Documentation Group PDO_SQLSRV-DSN(3)