Showing posts with label capture. Show all posts
Showing posts with label capture. Show all posts

Tuesday, March 27, 2012

Database benchmark

We are in the process of moving our databases from one server to another and
want to know what are some best to capture some performance benchmarks of
existing systems and compare it with the migrated database on the new server
so that at the end of the day performace is at best similar or better on the
new hardware.
Thanks
Hi Hassan
The obvious ones are to use perfmon and SQL Profiler over a variety of
periods/tests and produce comparative graphs/figures. You may also want to
replay profiles as a backend test.
If you are using a tool such as load runner or Visual Studio Team Test they
will collect their own stats that could be use to give a front end view.
As you are moving to a new system you should get a baseline using SQLIOSim
to make sure there are no issues with the new environment and have values
that you can use to compare against for future tests.
John
"Hassan" wrote:

> We are in the process of moving our databases from one server to another and
> want to know what are some best to capture some performance benchmarks of
> existing systems and compare it with the migrated database on the new server
> so that at the end of the day performace is at best similar or better on the
> new hardware.
> Thanks
>
>

Database benchmark

We are in the process of moving our databases from one server to another and
want to know what are some best to capture some performance benchmarks of
existing systems and compare it with the migrated database on the new server
so that at the end of the day performace is at best similar or better on the
new hardware.
ThanksHi Hassan :)
The obvious ones are to use perfmon and SQL Profiler over a variety of
periods/tests and produce comparative graphs/figures. You may also want to
replay profiles as a backend test.
If you are using a tool such as load runner or Visual Studio Team Test they
will collect their own stats that could be use to give a front end view.
As you are moving to a new system you should get a baseline using SQLIOSim
to make sure there are no issues with the new environment and have values
that you can use to compare against for future tests.
John
"Hassan" wrote:
> We are in the process of moving our databases from one server to another and
> want to know what are some best to capture some performance benchmarks of
> existing systems and compare it with the migrated database on the new server
> so that at the end of the day performace is at best similar or better on the
> new hardware.
> Thanks
>
>sql

Database benchmark

We are in the process of moving our databases from one server to another and
want to know what are some best to capture some performance benchmarks of
existing systems and compare it with the migrated database on the new server
so that at the end of the day performace is at best similar or better on the
new hardware.
ThanksHi Hassan
The obvious ones are to use perfmon and SQL Profiler over a variety of
periods/tests and produce comparative graphs/figures. You may also want to
replay profiles as a backend test.
If you are using a tool such as load runner or Visual Studio Team Test they
will collect their own stats that could be use to give a front end view.
As you are moving to a new system you should get a baseline using SQLIOSim
to make sure there are no issues with the new environment and have values
that you can use to compare against for future tests.
John
"Hassan" wrote:

> We are in the process of moving our databases from one server to another a
nd
> want to know what are some best to capture some performance benchmarks of
> existing systems and compare it with the migrated database on the new serv
er
> so that at the end of the day performace is at best similar or better on t
he
> new hardware.
> Thanks
>
>

Sunday, February 19, 2012

Data Type in DSV

I have Varchar column called "Age", which capture patient age. and I am trying to use grouping property of the Age dimension, since it is varchar type, the grouping is messed up, such as 20 - 4, 40 - 5. So I say, ok, I need to cast to int, so I change my age dimension to int, but the fact table need to be changed too, so I did cast(age as int) as Age, however I got error:

maxlength applies to string data type only, you cannot set column 'Age' property MaxLength to be non-negative number.

Any advice?

Dear Friend,

First when U Chages any data type in Fact Table. First remove all references in Cube. Suppose U want to change Age Datatype then first remove Age Measures from Cube or if any other reference is there like dimension using this field remove that from cube, then save, then process again. Now U can change that age datatype. Do fresh DataSourceView. Then add the things U removed. And Re-process your cube now this error will not come.