Author |
Topic  |
|
thisisgerald
Starting Member
Philippines
4 Posts |
Posted - 01/06/2015 : 01:02:26
|
Hi Admin/Gurus,
This is my first post here. :)
Would like to get comment/feedback on my case. User execute a program with select query which will have a result of 2-3 million of records.
Randomly, another user will experience problem creating data using another program. They access the same database but different tables. Do the resources used by the program with select query can be used by another select/insert/update query?
Thank you in advance!
Best Regards, thisisgerald
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
2179 Posts |
|
thisisgerald
Starting Member
Philippines
4 Posts |
Posted - 01/06/2015 : 02:21:34
|
Thanks Jackv!
I'm not a DBA and only know basic (developer side) on SQL.
Below is the table structure and in my understanding, it is okay. Is it?
Column Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullnSource Collation BR char no 2 no no no SQL_Latin1_General_CP1_CI_AS PRO char no 6 no no no SQL_Latin1_General_CP1_CI_AS TYP char no 2 no no no SQL_Latin1_General_CP1_CI_AS ARG char no 3 no no no SQL_Latin1_General_CP1_CI_AS DEA char no 8 no no no SQL_Latin1_General_CP1_CI_AS SEQ char no 4 no no no SQL_Latin1_General_CP1_CI_AS GLN char no 15 no no no SQL_Latin1_General_CP1_CI_AS COS char no 10 no no no SQL_Latin1_General_CP1_CI_AS CC char no 3 no no no SQL_Latin1_General_CP1_CI_AS BEI char no 1 no no no SQL_Latin1_General_CP1_CI_AS COD char no 4 no no no SQL_Latin1_General_CP1_CI_AS QUA char no 1 no no no SQL_Latin1_General_CP1_CI_AS EFF datetime no 8 no (n/a) (n/a) NULL POS datetime no 8 no (n/a) (n/a) NULL CMN char no 10 yes no yes SQL_Latin1_General_CP1_CI_AS DRC char no 2 yes no yes SQL_Latin1_General_CP1_CI_AS AMO numeric no 9 19 4 yes (n/a) (n/a) NULL SME char no 7 yes no yes SQL_Latin1_General_CP1_CI_AS SAC char no 15 yes no yes SQL_Latin1_General_CP1_CI_AS DES char no 70 yes no yes SQL_Latin1_General_CP1_CI_AS
Identity Seed Increment NotForReplication No identity column defined. NULL NULL NULL
RowGuidCol No rowguidcol column defined.
Data_located_on_filegroup PRIMARY
index_name index_description index_keys QCUPPK clustered, unique, primary key located on PRIMARY BR, PRO, TYP, ARG, DEA, SEQ, GLN, COS, CC, BEI, COD, QUA, EFF, POS
contraint_type constraint_name delete_action update_action status_enabled status_for_replication contraint_keys PRIMARY KEY (clustered) QCUPPK (n/a) (n/a) (n/a) (n/a) BR, PRO, TYP, ARG, DEA, SEQ, GLN, COS, CC, BEI, COD, QUA, EFF, POS
Thanks!
thisisgerald |
 |
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
2179 Posts |
Posted - 01/07/2015 : 01:34:48
|
There's a few different strategies you can apply to deal with queries on tables. Does the select statement used , utilise the indexes you have set up? Use the execution plan to analyse
Jack Vamvas -------------------- http://www.sqlserver-dba.com |
 |
|
thisisgerald
Starting Member
Philippines
4 Posts |
Posted - 01/07/2015 : 20:47:49
|
Here is the execution plan and I think it is okay because only those indexed fields are selected by a simple select query.

|
Edited by - thisisgerald on 01/09/2015 01:14:32 |
 |
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
2179 Posts |
Posted - 01/08/2015 : 01:25:14
|
@thisisgerald - the execution plan is not appearing.
Jack Vamvas -------------------- http://www.sqlserver-dba.com |
 |
|
gbritton
Flowing Fount of Yak Knowledge
2780 Posts |
Posted - 01/08/2015 : 07:10:39
|
you say that another user is having a problem in a different program. But you haven't yet said what the problem is the other user is experiencing. |
 |
|
thisisgerald
Starting Member
Philippines
4 Posts |
Posted - 01/09/2015 : 01:24:09
|
@jackv Cannot insert picture.
@gbritton The other user problem is sometimes time-out expired or connected to "blocking" issue. As stated in the scenario above, program 2 is accessed my many users (same functions) and only selected user is encountering the problem.
Thanks! thisisgerald |
 |
|
gbritton
Flowing Fount of Yak Knowledge
2780 Posts |
Posted - 01/09/2015 : 06:51:46
|
can you post some code? For example, stored procedures that are used by the programs use accessing the database or any pass through queries that are used. |
 |
|
|
Topic  |
|