86
Chapter 3
E
Start the SQL query analyzer as follows:
If you are using SQL Server 2005 or 2008, open SQL Server Management Studio and select the
New Query feature.
E
Connect to your Interviewer Server database server.
E
In the drop-down list of databases, select the sample database whose table or tables you want to
index.
E
In the Query window, type the following commands. You will need to repeat the commands for
each sample table you have created manually.
For tables that are used for Web (inbound) and/or telephone interviewing (outbound) projects:
CREATE NONCLUSTERED INDEX
Name
_idx_id_active
ON
TableName
(Id, Active)
CREATE NONCLUSTERED INDEX
Name
_idx_queue
ON
TableName
(Queue)
CREATE NONCLUSTERED INDEX
Name
_idx_active
ON
TableName
(Active)
Tables that are used for telephone interviewing projects need the following additional indexes:
CREATE NONCLUSTERED INDEX Participants_idx_id_active ON (Id, Active)
CREATE NONCLUSTERED INDEX Participants_idx_queue_sortid ON
SampleTableName
(Queue, SortId, ExpirationT
CREATE NONCLUSTERED INDEX Participants_idx_queue_appointmenttime ON
SampleTableName
(Queue, Appointmen
CREATE NONCLUSTERED INDEX Participants_idx_queue_recalltime
ON
SampleTableName
(Queue, RecallTime, Ex
E
If you also wish to index the associated history tables, type the following for each history table
in the database:
CONSTRAINT Participants_
ProjectName
_HistoryTable_pk PRIMARY KEY CLUSTERED (Id)
CREATE NONCLUSTERED INDEX Participants_
ProjectName
_HistoryTable_idx ON
SampleTableName
(SampleId)
CREATE NONCLUSTERED INDEX Participants_
ProjectName
_HistoryTable_idx_starttime
ON
SampleTableName
(StartTime)
E
Press F5 or click Execute Query (the green triangle).
E
If you have sample tables in more than one database, select the next database from the drop-down
list and repeat these commands for the tables in that database.
E
Save your changes and exit.
Increase the size of appRequestQueueLimit in the .NET framework
Each virtual directory on your Web server has a queue that stores requests to be passed from IIS to
the .NET Framework (ASP.NET). If an application’s queue becomes full, users see the HTTP
503, Server is busy, message and the queue starts to rejects requests. If your site uses telephone
interviewing, you should consider increasing the queue size to prevent the Phone activity
fl
ooding
its queue with requests. This change is strongly recommended, especially if you have many
interviewers working at the same time.
E
On each machine running the Web Service, navigate to
c:\Windows\Microsoft.Net\Framework\v3.5\CONFIG and open
machine.con
fi
g
.
E
Locate the line that starts
<httpRuntime ...>
(it is near the beginning of the
fi
le) and change the
value of the
appRequestQueueLimit
attribute from 100 to 1000.
