SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Project Plan


Project Plan

Author
Message
Shelley Allen
Shelley Allen
SSC-Enthusiastic
SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)

Group: General Forum Members
Points: 163 Visits: 106

could I get a copy of the project plan? sra98a@acu.edu

Thank you,


ALZDBA
ALZDBA
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12057 Visits: 8923

These are some items I've added to the great doc :
(formatting is not what it should be in html )

1.1 Starting Situation

Overview of the current situation.

1.1.1 File-volumes

Clustering Algemene tellingen.xls

ServerNaam

DbNaam

FileNaam

FileSizeMB

MBreserved

MBdata

MBindex

MBunused

Myserver

Mydb1

X:\MSSQL\Data\DDBAStatistics_Data.MDF

2.522

3.117,1

1.127,8

473,3

1.516,0

V:\MSSQL\Log\DDBAStatistics_Log.LDF

491

Mydb2

X:\MSSQL\data\Mydb2_Data.mdf

33.000

27.023,2

24.240,3

2.318,8

464,1

V:\MSSQL\LOG\Mydb2_log.ldf

5.250

Mydb3

X:\MSSQL\DATA\Mydb3_Data.mdf

38.500

37.869,9

35.227,3

2.583,6

59,1

V:\MSSQL\LOG\Mydb3_Log.ldf

4.507

Total

84.270

68.010

60.595

5.376

2.039

Servername

FileSize
MB

Reserved
MB

Datasize
MB

Indexsize
MB

Unused
MB

84.270

68.010

60.595

5.376

2.039

22.359

11.822

10.795

187

840

48.576

31.474

13.289

5.886

12.300

45.352

16.991

12.541

4.226

224

16.093

12.921

6.082

6.512

327

Grand Total

216.650

141.217

103.302

22.168

15.729

1.1.2 Input / Output Disk load

Overview 1 day activity

ServerName

Drive

Avg PctRead
Bytes

Avg PctWrite
Bytes

Avg PctReadIO

Avg Pct
Write
IO

Sum LogicalBytesTotal

I/O MB

Avg LogicalBytesPerSecond Mb

Max LogicalBytesPerSecond Mb

V

0,23

99,77

0,18

99,82

1.518.353.920

1.448

0,0159

15,7

X

11,91

36,96

11,70

37,18

89.007.619.072

84.884

0,9840

34,5

V

0,91

99,09

0,45

99,55

5.003.336.704

4.772

0,0529

12,9

X

38,50

57,17

27,88

67,79

71.539.668.480

68.226

0,7868

51,3

D

2,28

97,71

0,61

99,38

4.722.044.416

4.503

0,0508

17,1

E

11,96

45,79

14,49

43,26

5.773.902.336

5.506

0,0650

15,3

C

1,27

98,73

1,19

98,81

13.277.923.328

12.663

0,1466

15,0

D

1,91

1,52

1,89

1,53

20.051.034.112

19.122

0,2170

39,9

1.1.3 Queryloads

Op volgende servers werden traces van één dag ingesteld :

Server

Date

Started

Ended

19/10/2005

19/10/2005

19/10/2005

19/10/2005

19/10/2005

19/10/2005

20/10/2005

20/10/005

1.1.4 Linked Servers

List of Servers pointing to servers involved in this operation using linked servers.

Linked Servers that servers involved in this operation are pointing to.

Local_Server

TargetServer

xdate1

xdate2

Username

dbid

language

isrpcinmap

ishqoutmap

selfoutmap

16/09/2004 13:08

16/09/2004 13:08

0

NULL

0

1

0

02/01/2004 15:47

02/01/2004 15:47

0

NULL

0

1

0

17/03/2004 08:13

17/03/2004 08:13

0

NULL

0

1

0

30/01/2004 12:04

30/01/2004 12:04

0

NULL

0

1

0

1.1.5 ROI


Servername


€/Year

New
Cluster


€/ Year

Total

Difference

…..



Johan


Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


press F1 for solution, press shift+F1 for urgent solution :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
Nancy Lytle
Nancy Lytle
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 1

Could you send me a copy of the plan? I will use it as a starting point to create a SQL Server project template, which I can send back to you when I get it done.

Thanks,

Nancy

nlytle@mdon-line.com




NLytle
Max Xu
Max Xu
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1

Hi,Mat

Could you send me the copy of plan,very appreciate!!!

email: xuxinjian@gmail.com


Eric-210876
Eric-210876
SSC Journeyman
SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)SSC Journeyman (79 reputation)

Group: General Forum Members
Points: 79 Visits: 2

Hi, Can I also please get a copy...

erikrautenbach@hotmail.com

Thanks!




Regards,

Eric Rautenbach
P Harstvedt
P Harstvedt
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 267

Hi,

Can I have a copy of the plan too...

pharstvedt@yahoo.com

Thanks!


mahesh-272669
mahesh-272669
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 2

Hi friends,

I developed dts packages. I need to write document for the production consideration. Any one have document regarding this. pl help............km


Mat Hues
Mat Hues
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 14

Mahesh,

I'm not sure what you're asking: You've developed DTS packages and you need to document them as they are, or how to migrate them to a new SQL Server box?

I migrated several DTS packages during our cluster, using the DTS.DTSSQLServerStorageFlags library.

There are issues moving DTS packages, especially DTS package history.

http://www.sqldts.com/default.aspx?t=6&s=105&i=212&p=1&a=0

Good luck,

Matthew





Charles Bilodeau-369032
Charles Bilodeau-369032
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 18

While reading the post, I noticed that this would also apply to me. Can you send me a copy of that project Plan? It would be greatly apreaciated. My Email address is as follow:

charles.bilodeau@cgi.com.

Also I was asked to do a database analysis report for a client but I do not have any report templat I could use. Would any of you know of a good template or guide line I could use to create the report?


Mat Hues
Mat Hues
SSC Rookie
SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)SSC Rookie (45 reputation)

Group: General Forum Members
Points: 45 Visits: 14

Charles,

I will send you the project plan today. I never had the chance to add alzdba's additions to the project plan (see post 11/14/2005 by alzdba), so you might want to screen scrape that and add it to the project.

Database Analysis Report- Can you define what it is you're analyzing? I could make better recommendations/ideas if I knew more about what your client wants. Are you analyzing disk space, fragmentation, indexes, etc (performance tuning and optimization) or is this more about reporting?

Matthew





Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search