There are below check points on POS Performance :
1.Collect the data from Customer in a word document. ( Refer the attached file)
2.CHECK SYSTEM RAM SIZE : Check POS System RAM This should be as Per Ivend Hardware Guide (Take Screenshot and Put on Ticket)
3.CHECK SPACE AVILABLEa IN IVEND INSTALLATION DRIVE :Check Space Avilable In Ivend Installation Drive. Sufficient Space should be available In Drive. (also Take Print Screen of Disk Available of all drive and Put on Ticket)
4.CHECK SYSTEM CPU /MEMORY / DISK USAGES.
5.CHECK System CPU/MEMORY/DISK Usages. If anyone from all is high then check how much application is taking usage of CPU/RAM. If application other then POS application is taking high usages then ask Client/Partner to contact Local IT person to Resolve issue. (also Take Print Screen and Put on Ticket)
6.CHECK SQL DB
It may also be possible that Client is Using SQL SERVER EXPRESS EDITION AND Database Size is Near By Limit of SQL EXPRESS EDITION. IF DataBase SIZE is Near By DB Size Limit (10 gb) Then Ask Client to UpGrade DB.
7.CHECK TABLE FRAGMENTATION
8. You can use the following query to find the slow-running queries in the system.
Clicking on the query plan will also show you the recommended index.
Combine the output with your experience else we will end up with lots of indexes in the database which may be counterproductive.
If require, discuss with Support L3 to create an index with the IDX_[TableName]_[IndexColumns]_[DateinYYYYMMDD] a
********************************************************
select * from (SELECT
qs.last_worker_time/100000 As last_worker_time,
qs.last_elapsed_time/100000 As last_elapsed_time,
qs.max_dop,
qs.max_elapsed_time/100000 As max_elapsed_time,
last_execution_time,
qs.last_logical_reads,
qs.last_logical_writes,
SUBSTRING(
st.text,
(qs.statement_start_offset / 2) + 1,
(
(
CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(st.text) ELSE qs.statement_end_offset END - qs.statement_start_offset
) / 2
) + 1
) AS statement_text ,
sp.[query_plan]
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
cross apply sys.dm_exec_query_plan(qs.[plan_handle]) as sp
) s
where statement_text like 'select% %' and statement_text not like '%repreplication%' and statement_text not like '%contrx%'
--and statement_text not like 'insert%'
and max_elapsed_time > 2
ORDER BY last_elapsed_time desc, s.last_execution_time
***********************************************************************************************
Step 1 : Take Backup of DB.
Step 2 : Check allocation and structural integrity of all the objects.
DBCC CHECKDB (‘DataBase name’)
Step 3 : If above Query Successful then run below Query to check Fragmentation of Major tables
SELECT OBJECT_NAME(i.OBJECT_ID) AS TableName, i.name AS IndexName, indexstats.avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED') indexstats
INNER JOIN sys.indexes i ON i.OBJECT_ID = indexstats.OBJECT_ID
WHERE indexstats.avg_fragmentation_in_percent > 30
AND i.index_id = indexstats.index_id
AND OBJECT_NAME(i.OBJECT_ID) IN
('InvInventoryItem','TrxTransactionSaleItem','TrxTransactionAttribute',
'TrxTransactionPayment','TrxTransaction','InvGoodReceipt',
'TrxTransactionStatus','PrcPriceMatrix','TrxTransactionStatus',
'TrxTransactionSalesPerson','TrxTransactionPayment',
'TrxTransactionReceipt','RepIntegrationLog','RepReplicationTransaction')
ORDER BY 1 ASC
Step 4 : if the above query will return any row then ask Client/Partner to Check to contact their DBA to Optimize DB.
CHECK LOG FILE
Open DataBase Properties => Click on Files option Under Select a page => Check Log file Size. (If Log File Size is Huge Then This May also Impact Performance) so ask Client/Partner to contact DBA to Resolve this issue.
8.CHECK SPACE AVAILABLE IN DB
Open DataBase Properties => Click on General option Under Select a page => Check Space Available (Value Should be Near By 10% of Size OR should not be Less Then 100 MB)
Check Space Available on System
If Space problem then ask Client/Partner to contact DBA to Resolve this issue