1

Topic: Optimization of productivity of requests of a SQL Server 2000

Kind time of days. I the beginner in DB administration, was required learning SQL
I ask the help, transited a certain test and the multiple choice question floated here such here.
Re-read literature ton, shoveled all Internet.
The answer explicitly lies on surfaces, but an essence in that that I that cannot understand a question plainly if fairly.
Question.

wrote:

you get into the role db_owner databases userdb. The size of basis makes 10 Gb, about 85 % of the information of basis consists of the tables containing the static help information.
What sequence of actions allows to raise productivity of requests and to optimize process of database backup MS a SQL Server 2000?
1. To create a new database, to use utilities DTS for relocation in this database of reference tables
2. To use master Database Maintenance Planner for determination of intervals of reserve copying, a defragmentation of indexes, integrity check of the data
3. To create indexed representations on the basis of changeable tables
4. To create 2 file groups, in one file group to place tables with handbook data, in another - changeable tables
5. To create indexed representations on the basis of reference tables

In my opinion the question from indexing area, however could not find the answer to this point in question in the given section.

2

Re: Optimization of productivity of requests of a SQL Server 2000

Profit7;
How indexing affects process of reserve copying?
Think Profit7, think.

3

Re: Optimization of productivity of requests of a SQL Server 2000

The answer is obvious:
1. To install MS SQL 2017 and  RAM gigabyte.
2. All to put in .

4

Re: Optimization of productivity of requests of a SQL Server 2000

Profit7;
2,3,5 - it is possible to throw off at once.
Choice between 1 and 4 - to separate a statics and dynamics, and it is partite them . One is more rare, another to a thicket.

5

Re: Optimization of productivity of requests of a SQL Server 2000

Massa52 wrote:

Profit7;
2,3,5 - it is possible to throw off at once.
Choice between 1 and 4 - to separate a statics and dynamics, and it is partite them . One is more rare, another to a thicket.

Sit down, .
>> allows to raise productivity of requests and to optimize process of reserve copying

6

Re: Optimization of productivity of requests of a SQL Server 2000

aleks222;
Like it is a question about SQL 2000 - unless there there were indexed representations?

7

Re: Optimization of productivity of requests of a SQL Server 2000

Massa52 wrote:

aleks222;
Like it is a question about SQL 2000 - unless there there were indexed representations?

There they appeared.
PS. 2000 was the big break.

8

Re: Optimization of productivity of requests of a SQL Server 2000

p-server wrote:

I Demand a problem on a SQL Server 4.2

That moves these people, in an adjacent subject cannot define how many storage  occupies, and already something demands

9

Re: Optimization of productivity of requests of a SQL Server 2000

There are no reasons as far as I understand. The third sleepless night expects me. sad

Relic Hunter wrote:

How indexing affects process of reserve copying?
Think Profit7, think.

You will not prompt as where it is possible to esteem on the given subjects?

aleks222 wrote:

the Answer is obvious:
1. To install MS SQL 2017 and  RAM gigabyte.
2. All to put in .

It agree, it is possible to go on the least way of resistance, however unfortunately it not the task in view decision in the given specific case.

10

Re: Optimization of productivity of requests of a SQL Server 2000

Profit7;
If the test for DBA the answer, as though, is obvious.
As if it is the test from MS it is necessary to consider "logic MS" smile

11

Re: Optimization of productivity of requests of a SQL Server 2000

aleks222 wrote:

it is passed...
Sit down, .
>> allows to raise productivity of requests and to optimize process of reserve copying

So Massa52 that part where there will be reference manuals, makes read-only.
Then requests will not create lock in the invariable data => productivity increase.

12

Re: Optimization of productivity of requests of a SQL Server 2000

Eleanor wrote:

it is passed...
So Massa52 that part where there will be reference manuals, makes read-only.
Then requests will not create lock in the invariable data => productivity increase.

Can tell to us what locks readers to other readers will create?

13

Re: Optimization of productivity of requests of a SQL Server 2000

Mind wrote:

Can tell to us what locks readers to other readers will create?

shared locks. In read-only a mode they are not superimposed at all and the server is not engaged in their tracing that raises productivity

14

Re: Optimization of productivity of requests of a SQL Server 2000

stenford wrote:

shared locks

IS and S  if that...

stenford wrote:

read-only a mode they are not superimposed at all and the server is not engaged in their tracing what raises productivity

and how many nanoseconds it is possible to benefit?

15

Re: Optimization of productivity of requests of a SQL Server 2000

wrote:

and how many nanoseconds it is possible to benefit?

Also storage will be released, which was occupied with locks.
It will be possible to spend it for something more useful.
Interesting, what characteristics at servers in 2000 were. 10  bases then probably were not small, and servers were a match for them.

16

Re: Optimization of productivity of requests of a SQL Server 2000

Eleanor wrote:

it is passed...
Also storage will be released, which was occupied with locks.
It will be possible to spend it for something more useful.
Interesting, what characteristics at servers in 2000 were. 10  bases then probably were not small, and servers were a match for them.

In current conditions at us of ~3 % of storage on all locks. How many they in peak occupy them shared, knows one . (As a whole, it is more favourable rcsi to stir up, than any data in r/o to throw). And even absence conditions rcsi struggle for 3 % of storage looks doubtful.

17

Re: Optimization of productivity of requests of a SQL Server 2000

And, yes, tests on a product which 10 is not supported years, look almost the same as also a questionnaire on windows 95.

18

Re: Optimization of productivity of requests of a SQL Server 2000

wrote:

and how many nanoseconds it is possible to benefit?

How many it will be benefited, there were somewhere tests how much read-only raises productivity, results were nonzero. Besides it it is possible to adjust indexes how many it wants since any  is not present. There is no statistics update . In general if the data static - that  also recommends to translate basis in read-only

19

Re: Optimization of productivity of requests of a SQL Server 2000

Sergey Alekseevich wrote:

In current conditions at us of ~3 % of storage on all locks. How many they in peak occupy them shared, knows one .

At me in the core as though there are servers from 7-9-11 %. Ridiculously to tell, even 43 % are on the server with one basis of the distributor.
Naturally, I understand that Read only anything especial does not give, but same test questions, instead of real operation.

20

Re: Optimization of productivity of requests of a SQL Server 2000

Eleanor wrote:

it is passed...
So Massa52 that part where there will be reference manuals, makes read-only.
Then requests will not create lock in the invariable data => productivity increase.

As far as I understand statistics tables created manually can be translated in a mode read-only. But statistics on other requests are permanently updated , those that  does itself automatically depending on repeating requests. Then completely to block statistics creation that in turn damages productivity of requests.
I will tend to the answer No3

wrote:

to Create indexed representations on the basis of changeable tables

And why I can not explain in view of absence of experience and low knowledge a part floor-mat.

21

Re: Optimization of productivity of requests of a SQL Server 2000

wrote:

on the basis of changeable tables

wrote:

But statistics on other requests are permanently updated , those that  does itself automatically depending on repeating requests. Then completely to block statistics creation that in turn damages productivity of requests.

Statistics this such mythical creation and about it only legends walk, here new \

22

Re: Optimization of productivity of requests of a SQL Server 2000

[/quote] statistics this such mythical creation and about it only legends walk, here new \[/quote]
Why the mythical? Quite to itself such explicit.
[img=http://i12.pixs.ru/storage/0/3/0/Skrinshot0_3836794_27801030.png]

23

Re: Optimization of productivity of requests of a SQL Server 2000

Profit7 wrote:

As far as I understand statistics tables

How much I understand, it is wrong transfer table statistics, statistics of tables?
Do not read badly translated documentation, use the original in English.

24

Re: Optimization of productivity of requests of a SQL Server 2000

To create 2 file groups, in one file group to place tables with handbook data, in another - changeable tables

25

Re: Optimization of productivity of requests of a SQL Server 2000

PS db_owner cannot fulfill item 1 on safety.