1

Topic: Increase of productivity SQL Express

Is working  application which cannot neither be rewritten, nor to replace.
Is  the computer with the processor of Intel and 32 storages. Is SQL Express 2014.
What it is possible to make for performance gain without license purchase on Standard?
While it was invented only:
To deliver  and SQL 32 bit. Express 2014 still supports. All the same it is more 1 SQL does not take;
To disconnect hyperthreading. 4 flows SQL all the same there are more does not take;
To deliver ramdrive in storage above 4 (PAE/AWE) and to suppose on it files tempdb on number of kernels, not flows.

2

Re: Increase of productivity SQL Express

tunknown wrote:

Is working  application which cannot neither be rewritten, nor to replace.
Is  the computer with the processor of Intel and 32 storages. Is SQL Express 2014.
What it is possible to make for performance gain without license purchase on Standard?
While it was invented only:
To deliver  and SQL 32 bit. Express 2014 still supports. All the same it is more 1 SQL does not take;
To disconnect hyperthreading. 4 flows SQL all the same there are more does not take;
To deliver ramdrive in storage above 4 (PAE/AWE) and to suppose on it files tempdb on number of kernels, not flows.

Well, at first, it is necessary to understand that productivity of that you brakes also be going to refine
[spoiler speaking in images] if the sportsman badly runs 10th hour successively and water changeover  can not help [/spoiler] is necessary to it

3

Re: Increase of productivity SQL Express

komrad wrote:

well, at first, it is necessary to understand that productivity of that you brakes also be going to refine

tunknown wrote:

Is working  application which cannot neither be rewritten, nor to replace .

The general recommendations are necessary to me, it is desirable, without setting of the additional equipment and a paid software.
Crookedly written application brakes.

4

Re: Increase of productivity SQL Express

tunknown;
You do not check, but  it is possible to accelerate application only one method - rewriting it "exactly".
All remaining - "the extensive way" developments also dares at the expense of increase of productivity of iron, increase of edition of the server and all remaining that you to do do not walk / cannot...

5

Re: Increase of productivity SQL Express

tunknown wrote:

the general recommendations are necessary To me, it is desirable, without setting of the additional equipment and a paid software.
Crookedly written application Brakes.

It at you is twisted on the same host?
The general recommendations can not solve a problem.
If you accelerate and so fast parts of system, whether it helps business?
Can at you there banal locks on a sequel?
Preventive operations are fulfilled with basis?
Parts of system which can be twisted much enough and to twist at random there is no sense.
Disk subsystem at you what?

6

Re: Increase of productivity SQL Express

tunknown wrote:

Is working  application which cannot neither be rewritten, nor to replace.
Is  the computer with the processor of Intel and 32 storages. Is SQL Express 2014.
What it is possible to make for performance gain without license purchase on Standard?
While it was invented only:
To deliver  and SQL 32 bit. Express 2014 still supports. All the same it is more 1 SQL does not take;
To disconnect hyperthreading. 4 flows SQL all the same there are more does not take;
To deliver ramdrive in storage above 4 (PAE/AWE) and to suppose on it files tempdb on number of kernels, not flows.

Yes, it can help.
Still it is possible to accelerate productivity of a disk subsystem, to transfer all on SSD if it is not transferred yet.
But all enumerated, certainly, can not affect generally in any way productivity, if a problem not in the processor, storage and a disk. As already above wrote.

7

Re: Increase of productivity SQL Express

The best gain gives SSD. In times.

8

Re: Increase of productivity SQL Express

L_argo wrote:

the Best gain gives SSD. In times.

If to disks there are no calls it is doubtful.

9

Re: Increase of productivity SQL Express

tunknown;
Normal recommendations to divide tempdb, logs, from bases on different disks to deliver the fast processor more, than on 4 kernels.  not the fact that helps. Format disks under 64 a cluster.

10

Re: Increase of productivity SQL Express

Anna wrote:

tunknown;
You do not check, but  it is possible to accelerate application only one method - rewriting it "exactly".
All remaining - "the extensive way" developments also dares at the expense of increase of productivity of iron, increase of edition of the server and all remaining that you to do do not walk / cannot...

Still it is possible to delete all data from basis.

11

Re: Increase of productivity SQL Express

tunknown wrote:

it is passed...
it is passed...
The general recommendations are necessary to me, it is desirable, without setting of the additional equipment and a paid software.
Crookedly written application brakes.

to Analyze requests and to put in order indexes.

12

Re: Increase of productivity SQL Express

Mind wrote:

it is passed...
Still it is possible to delete all data from basis.

It is not necessary  bosh. To it it is sick.
The lady of the right, correct  - to rewrite requests,  the correct indexes, not to drag on client Over  lines.
Disks, storage and the processor is a way weak in spirit, the leader in lockup.

13

Re: Increase of productivity SQL Express

, and I would deliver a sequel 2017/2016 (SP1)  (for there many features from  are accessible to application). There under a cowl it is a lot of improvings and as that that advised the main variant earlier - to look what activity on a server and that brakes. The same .

14

Re: Increase of productivity SQL Express

On usage of scripts questions here what arose:
1.  to create well. But how them to delete then? Removal too should be adjusted any job.
2. To be connected to SQL - login-password are necessary. And in a script to register in an explicit form passwords such to itself.
Who as solves these questions?

15

Re: Increase of productivity SQL Express

gvozd13 wrote:

On usage of scripts questions here what arose:
1.  to create well. But how them to delete then? Removal too should be adjusted any job.
2. To be connected to SQL - login-password are necessary. And in a script to register in an explicit form passwords such to itself.
Who as solves these questions?

1. Powershell -  . And to delete "old files in a folder, leaving, say, 10 last by date" - for  to do.
2. Open for itself Windows-authorization.

16

Re: Increase of productivity SQL Express

aleks222;
It gvozd13 by mistake  a copy of the question from a subject about creation .