|
|
|
|
|
Server Sizing Recommendations
5 - 15 Centres - SQL Express, single CPU, 1G RAM,
10 - 50 Centres - SQL Server, Dual Xeon / Athlon 4GB RAM, separate drives for log and data files.
50 - 200 Centres - SQL Server, fast Dual Xeon / Athlon 8GB RAM, separate drives for log and data files.
200 - 1000 Centres - SQL Server, Quad Xeon 8GB+ RAM, separate 15K drives for OS, log and data files
Note: All data and log drives should be RAID 1 or RAID 10. RAID 5 arrays do not usually have the write performance to justify their use with SQL Server.
Server Bandwidth Recommendations
5 - 50 Users - 512Kbit / 512Kbit
50 - 200 Users - 1Mbit / 1Mbit
200 - 1000 Users - 2Mbit / 2Mbit
Please note: These recommendations are indicative only. Actual requirements will vary based on usage patterns.
SQL Server Performance Maintenance
To keep your QikKids 4 Enterprise SQL database performing quickly, we suggest scheduling the following 2 steps (replace YOUR_QK_DB_NAME_HERE with the name of your database). These steps are available as .sql files in the Tools\QikKids\SQLScripts scripts of your QikKids installation CD.
1) Rebuild Indexes
USE YOUR_QK_DB_NAME_HERE
DECLARE @TableName varchar(255)
DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor
2) Update Statistics
USE YOUR_QK_DB_NAME_HERE
DECLARE @TableName varchar(255)
DECLARE @SQLString NVARCHAR(1028)
DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
SET @SQLString = 'UPDATE STATISTICS ' + @TableName + ' WITH FULLSCAN'
EXEC(@SQLString)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor
Note: This should be run weekly but out of business hours