I have two database (structurly idenical) on the same SQL server, first
working good, but second is very slow
(noticed from web aplication)
I would like the same speed for both database
is there any database parameters need to be set to make same speed
Thanks for your answerHi
What is about amount of data contain on both database? Is it the same?
Did you identify what queries are caused to the problem? If you did, have
you tried to improve them?
"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>|||"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
It is not so hard to make two databases equally slow just put "delay for" in
key places...|||Bojidar
What did you mean "put "delay for" in> key places..."?
"Bojidar Alexandrov" <bojo_do_not_spam@.kodar.net> wrote in message
news:%23x1h563UEHA.2564@.TK2MSFTNGP11.phx.gbl...
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
>
> It is not so hard to make two databases equally slow just put "delay for"
in
> key places...
>|||We can say amount of data is the same (very small variation), and number of
users are almost the same,
I didn't mention, there is also two web aplication (ASP, medical aplication)
that are using mentioned database,
aplication are located on the same IIS server, and everting is working on
LAN (one hospital)
maybe I must set some parametrs in IIS '
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eCOUd23UEHA.2692@.TK2MSFTNGP09.phx.gbl...
> Hi
> What is about amount of data contain on both database? Is it the same?
> Did you identify what queries are caused to the problem? If you did, have
> you tried to improve them?
>
>
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
>|||kidding
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u2AsB%233UEHA.2408@.tk2msftngp13.phx.gbl...
> Bojidar
> What did you mean "put "delay for" in> key places..."?
> "Bojidar Alexandrov" <bojo_do_not_spam@.kodar.net> wrote in message
> news:%23x1h563UEHA.2564@.TK2MSFTNGP11.phx.gbl...
first[vbcol=seagreen]
for"[vbcol=seagreen]
> in
>|||You should consider the physical file system... Are the databases loaded to
the same or equivalent disks using the same filegroups/files?
Have both of the databases been maintained ( indexdefrag and update
statistics.)
As one other poster mentioned... If you feel like the problem is in the
database, isolate one query which works more slowly in one db than the
other, and look at the query plan... If you can not isolate this to a
single query ( or a group of queries) it might not be a database problem.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>|||DS1979,
You might want to compare that the databases are indeed identical using
a third party tool such as http://www.red-gate.com/SQL_Compare.htm or
look at http://www.aspfaq.com/show.asp?id=2209 for more options.
This will highlight any differences. Once you have confirmed they are
the same, update statistics and defrag indexes. Also check that the
databases are residing on the same disk subsystem by running sp_helpfile
in each db.
Use Profiler to check the worst performing queries, then look at the
execution plans of those queries - there could be indexing differences
between the databases.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
DS1979 wrote:
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>|||Thanks, I think maybe I found problem
See this
I found someting new in this story,
I found that administrator did this
1) copy xxx.mdf and xxx_log.ldf from (copy from file system) server A to
server B
2) Make new database on server B
3) Change path in server B database >>> properties >>> Data file and
Transaction Log to server B\xxx.mdf and server B\xxx_log.ldf
4) Put database server B\ working
no_sp_detach, no sp_attach ?
What do you think is this main reason for slow working (faster database
didn't moved from orginal location and it's working good)
What is the best solution to repair this situation now ?
Thanks, again
"Wayne Snyder" <wayne.snyder@.mariner-usa.com> wrote in message
news:%23PMikB5UEHA.3428@.TK2MSFTNGP12.phx.gbl...
> You should consider the physical file system... Are the databases loaded
to
> the same or equivalent disks using the same filegroups/files?
> Have both of the databases been maintained ( indexdefrag and update
> statistics.)
> As one other poster mentioned... If you feel like the problem is in the
> database, isolate one query which works more slowly in one db than the
> other, and look at the query plan... If you can not isolate this to a
> single query ( or a group of queries) it might not be a database problem.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
>
Showing posts with label aplication. Show all posts
Showing posts with label aplication. Show all posts
Thursday, March 29, 2012
database speed
I have two database (structurly idenical) on the same SQL server, first
working good, but second is very slow
(noticed from web aplication)
I would like the same speed for both database
is there any database parameters need to be set to make same speed
Thanks for your answer
Hi
What is about amount of data contain on both database? Is it the same?
Did you identify what queries are caused to the problem? If you did, have
you tried to improve them?
"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>
|||"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
It is not so hard to make two databases equally slow just put "delay for" in
key places...
|||Bojidar
What did you mean "put "delay for" in> key places..."?
"Bojidar Alexandrov" <bojo_do_not_spam@.kodar.net> wrote in message
news:%23x1h563UEHA.2564@.TK2MSFTNGP11.phx.gbl...
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
>
> It is not so hard to make two databases equally slow just put "delay for"
in
> key places...
>
|||We can say amount of data is the same (very small variation), and number of
users are almost the same,
I didn't mention, there is also two web aplication (ASP, medical aplication)
that are using mentioned database,
aplication are located on the same IIS server, and everting is working on
LAN (one hospital)
maybe I must set some parametrs in IIS ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eCOUd23UEHA.2692@.TK2MSFTNGP09.phx.gbl...
> Hi
> What is about amount of data contain on both database? Is it the same?
> Did you identify what queries are caused to the problem? If you did, have
> you tried to improve them?
>
>
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
>
|||kidding
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u2AsB%233UEHA.2408@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Bojidar
> What did you mean "put "delay for" in> key places..."?
> "Bojidar Alexandrov" <bojo_do_not_spam@.kodar.net> wrote in message
> news:%23x1h563UEHA.2564@.TK2MSFTNGP11.phx.gbl...
first[vbcol=seagreen]
for"
> in
>
|||You should consider the physical file system... Are the databases loaded to
the same or equivalent disks using the same filegroups/files?
Have both of the databases been maintained ( indexdefrag and update
statistics.)
As one other poster mentioned... If you feel like the problem is in the
database, isolate one query which works more slowly in one db than the
other, and look at the query plan... If you can not isolate this to a
single query ( or a group of queries) it might not be a database problem.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>
|||DS1979,
You might want to compare that the databases are indeed identical using
a third party tool such as http://www.red-gate.com/SQL_Compare.htm or
look at http://www.aspfaq.com/show.asp?id=2209 for more options.
This will highlight any differences. Once you have confirmed they are
the same, update statistics and defrag indexes. Also check that the
databases are residing on the same disk subsystem by running sp_helpfile
in each db.
Use Profiler to check the worst performing queries, then look at the
execution plans of those queries - there could be indexing differences
between the databases.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
DS1979 wrote:
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>
|||Thanks, I think maybe I found problem
See this
I found someting new in this story,
I found that administrator did this
1) copy xxx.mdf and xxx_log.ldf from (copy from file system) server A to
server B
2) Make new database on server B
3) Change path in server B database >>> properties >>> Data file and
Transaction Log to server B\xxx.mdf and server B\xxx_log.ldf
4) Put database server B\ working
no_sp_detach, no sp_attach ?
What do you think is this main reason for slow working (faster database
didn't moved from orginal location and it's working good)
What is the best solution to repair this situation now ?
Thanks, again
"Wayne Snyder" <wayne.snyder@.mariner-usa.com> wrote in message
news:%23PMikB5UEHA.3428@.TK2MSFTNGP12.phx.gbl...
> You should consider the physical file system... Are the databases loaded
to
> the same or equivalent disks using the same filegroups/files?
> Have both of the databases been maintained ( indexdefrag and update
> statistics.)
> As one other poster mentioned... If you feel like the problem is in the
> database, isolate one query which works more slowly in one db than the
> other, and look at the query plan... If you can not isolate this to a
> single query ( or a group of queries) it might not be a database problem.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
>
working good, but second is very slow
(noticed from web aplication)
I would like the same speed for both database
is there any database parameters need to be set to make same speed
Thanks for your answer
Hi
What is about amount of data contain on both database? Is it the same?
Did you identify what queries are caused to the problem? If you did, have
you tried to improve them?
"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>
|||"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
It is not so hard to make two databases equally slow just put "delay for" in
key places...
|||Bojidar
What did you mean "put "delay for" in> key places..."?
"Bojidar Alexandrov" <bojo_do_not_spam@.kodar.net> wrote in message
news:%23x1h563UEHA.2564@.TK2MSFTNGP11.phx.gbl...
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
>
> It is not so hard to make two databases equally slow just put "delay for"
in
> key places...
>
|||We can say amount of data is the same (very small variation), and number of
users are almost the same,
I didn't mention, there is also two web aplication (ASP, medical aplication)
that are using mentioned database,
aplication are located on the same IIS server, and everting is working on
LAN (one hospital)
maybe I must set some parametrs in IIS ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eCOUd23UEHA.2692@.TK2MSFTNGP09.phx.gbl...
> Hi
> What is about amount of data contain on both database? Is it the same?
> Did you identify what queries are caused to the problem? If you did, have
> you tried to improve them?
>
>
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
>
|||kidding
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u2AsB%233UEHA.2408@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Bojidar
> What did you mean "put "delay for" in> key places..."?
> "Bojidar Alexandrov" <bojo_do_not_spam@.kodar.net> wrote in message
> news:%23x1h563UEHA.2564@.TK2MSFTNGP11.phx.gbl...
first[vbcol=seagreen]
for"
> in
>
|||You should consider the physical file system... Are the databases loaded to
the same or equivalent disks using the same filegroups/files?
Have both of the databases been maintained ( indexdefrag and update
statistics.)
As one other poster mentioned... If you feel like the problem is in the
database, isolate one query which works more slowly in one db than the
other, and look at the query plan... If you can not isolate this to a
single query ( or a group of queries) it might not be a database problem.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>
|||DS1979,
You might want to compare that the databases are indeed identical using
a third party tool such as http://www.red-gate.com/SQL_Compare.htm or
look at http://www.aspfaq.com/show.asp?id=2209 for more options.
This will highlight any differences. Once you have confirmed they are
the same, update statistics and defrag indexes. Also check that the
databases are residing on the same disk subsystem by running sp_helpfile
in each db.
Use Profiler to check the worst performing queries, then look at the
execution plans of those queries - there could be indexing differences
between the databases.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
DS1979 wrote:
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>
|||Thanks, I think maybe I found problem
See this
I found someting new in this story,
I found that administrator did this
1) copy xxx.mdf and xxx_log.ldf from (copy from file system) server A to
server B
2) Make new database on server B
3) Change path in server B database >>> properties >>> Data file and
Transaction Log to server B\xxx.mdf and server B\xxx_log.ldf
4) Put database server B\ working
no_sp_detach, no sp_attach ?
What do you think is this main reason for slow working (faster database
didn't moved from orginal location and it's working good)
What is the best solution to repair this situation now ?
Thanks, again
"Wayne Snyder" <wayne.snyder@.mariner-usa.com> wrote in message
news:%23PMikB5UEHA.3428@.TK2MSFTNGP12.phx.gbl...
> You should consider the physical file system... Are the databases loaded
to
> the same or equivalent disks using the same filegroups/files?
> Have both of the databases been maintained ( indexdefrag and update
> statistics.)
> As one other poster mentioned... If you feel like the problem is in the
> database, isolate one query which works more slowly in one db than the
> other, and look at the query plan... If you can not isolate this to a
> single query ( or a group of queries) it might not be a database problem.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
>
database speed
I have two database (structurly idenical) on the same SQL server, first
working good, but second is very slow
(noticed from web aplication)
I would like the same speed for both database
is there any database parameters need to be set to make same speed
Thanks for your answerHi
What is about amount of data contain on both database? Is it the same?
Did you identify what queries are caused to the problem? If you did, have
you tried to improve them?
"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>|||"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
It is not so hard to make two databases equally slow just put "delay for" in
key places...|||Bojidar
What did you mean "put "delay for" in> key places..."?
"Bojidar Alexandrov" <bojo_do_not_spam@.kodar.net> wrote in message
news:%23x1h563UEHA.2564@.TK2MSFTNGP11.phx.gbl...
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
> > I have two database (structurly idenical) on the same SQL server, first
> > working good, but second is very slow
> > (noticed from web aplication)
> >
> > I would like the same speed for both database
>
> It is not so hard to make two databases equally slow just put "delay for"
in
> key places...
>|||We can say amount of data is the same (very small variation), and number of
users are almost the same,
I didn't mention, there is also two web aplication (ASP, medical aplication)
that are using mentioned database,
aplication are located on the same IIS server, and everting is working on
LAN (one hospital)
maybe I must set some parametrs in IIS '
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eCOUd23UEHA.2692@.TK2MSFTNGP09.phx.gbl...
> Hi
> What is about amount of data contain on both database? Is it the same?
> Did you identify what queries are caused to the problem? If you did, have
> you tried to improve them?
>
>
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
> > I have two database (structurly idenical) on the same SQL server, first
> > working good, but second is very slow
> > (noticed from web aplication)
> >
> > I would like the same speed for both database
> > is there any database parameters need to be set to make same speed
> >
> > Thanks for your answer
> >
> >
>|||kidding
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u2AsB%233UEHA.2408@.tk2msftngp13.phx.gbl...
> Bojidar
> What did you mean "put "delay for" in> key places..."?
> "Bojidar Alexandrov" <bojo_do_not_spam@.kodar.net> wrote in message
> news:%23x1h563UEHA.2564@.TK2MSFTNGP11.phx.gbl...
> >
> > "DS1979" <ds19792004@.yahoo.com> wrote in message
> > news:caovo2$qcg$1@.ls219.htnet.hr...
> > > I have two database (structurly idenical) on the same SQL server,
first
> > > working good, but second is very slow
> > > (noticed from web aplication)
> > >
> > > I would like the same speed for both database
> >
> >
> > It is not so hard to make two databases equally slow just put "delay
for"
> in
> > key places...
> >
> >
>|||You should consider the physical file system... Are the databases loaded to
the same or equivalent disks using the same filegroups/files?
Have both of the databases been maintained ( indexdefrag and update
statistics.)
As one other poster mentioned... If you feel like the problem is in the
database, isolate one query which works more slowly in one db than the
other, and look at the query plan... If you can not isolate this to a
single query ( or a group of queries) it might not be a database problem.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>|||Out of curiousity have set a performance monitor for both
servers, it could be that one server is being used for a
lot more work than the other.
Other than that just follow what the guys have said.
J
>--Original Message--
>I have two database (structurly idenical) on the same SQL
server, first
>working good, but second is very slow
>(noticed from web aplication)
>I would like the same speed for both database
>is there any database parameters need to be set to make
same speed
>Thanks for your answer
>
>.
>|||DS1979,
You might want to compare that the databases are indeed identical using
a third party tool such as http://www.red-gate.com/SQL_Compare.htm or
look at http://www.aspfaq.com/show.asp?id=2209 for more options.
This will highlight any differences. Once you have confirmed they are
the same, update statistics and defrag indexes. Also check that the
databases are residing on the same disk subsystem by running sp_helpfile
in each db.
Use Profiler to check the worst performing queries, then look at the
execution plans of those queries - there could be indexing differences
between the databases.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
DS1979 wrote:
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>|||Thanks, I think maybe I found problem
See this
I found someting new in this story,
I found that administrator did this
1) copy xxx.mdf and xxx_log.ldf from (copy from file system) server A to
server B
2) Make new database on server B
3) Change path in server B database >> properties >> Data file and
Transaction Log to server B\xxx.mdf and server B\xxx_log.ldf
4) Put database server B\ working
no_sp_detach, no sp_attach ?
What do you think is this main reason for slow working (faster database
didn't moved from orginal location and it's working good)
What is the best solution to repair this situation now ?
Thanks, again
"Wayne Snyder" <wayne.snyder@.mariner-usa.com> wrote in message
news:%23PMikB5UEHA.3428@.TK2MSFTNGP12.phx.gbl...
> You should consider the physical file system... Are the databases loaded
to
> the same or equivalent disks using the same filegroups/files?
> Have both of the databases been maintained ( indexdefrag and update
> statistics.)
> As one other poster mentioned... If you feel like the problem is in the
> database, isolate one query which works more slowly in one db than the
> other, and look at the query plan... If you can not isolate this to a
> single query ( or a group of queries) it might not be a database problem.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
> > I have two database (structurly idenical) on the same SQL server, first
> > working good, but second is very slow
> > (noticed from web aplication)
> >
> > I would like the same speed for both database
> > is there any database parameters need to be set to make same speed
> >
> > Thanks for your answer
> >
> >
>
working good, but second is very slow
(noticed from web aplication)
I would like the same speed for both database
is there any database parameters need to be set to make same speed
Thanks for your answerHi
What is about amount of data contain on both database? Is it the same?
Did you identify what queries are caused to the problem? If you did, have
you tried to improve them?
"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>|||"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
It is not so hard to make two databases equally slow just put "delay for" in
key places...|||Bojidar
What did you mean "put "delay for" in> key places..."?
"Bojidar Alexandrov" <bojo_do_not_spam@.kodar.net> wrote in message
news:%23x1h563UEHA.2564@.TK2MSFTNGP11.phx.gbl...
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
> > I have two database (structurly idenical) on the same SQL server, first
> > working good, but second is very slow
> > (noticed from web aplication)
> >
> > I would like the same speed for both database
>
> It is not so hard to make two databases equally slow just put "delay for"
in
> key places...
>|||We can say amount of data is the same (very small variation), and number of
users are almost the same,
I didn't mention, there is also two web aplication (ASP, medical aplication)
that are using mentioned database,
aplication are located on the same IIS server, and everting is working on
LAN (one hospital)
maybe I must set some parametrs in IIS '
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eCOUd23UEHA.2692@.TK2MSFTNGP09.phx.gbl...
> Hi
> What is about amount of data contain on both database? Is it the same?
> Did you identify what queries are caused to the problem? If you did, have
> you tried to improve them?
>
>
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
> > I have two database (structurly idenical) on the same SQL server, first
> > working good, but second is very slow
> > (noticed from web aplication)
> >
> > I would like the same speed for both database
> > is there any database parameters need to be set to make same speed
> >
> > Thanks for your answer
> >
> >
>|||kidding
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:u2AsB%233UEHA.2408@.tk2msftngp13.phx.gbl...
> Bojidar
> What did you mean "put "delay for" in> key places..."?
> "Bojidar Alexandrov" <bojo_do_not_spam@.kodar.net> wrote in message
> news:%23x1h563UEHA.2564@.TK2MSFTNGP11.phx.gbl...
> >
> > "DS1979" <ds19792004@.yahoo.com> wrote in message
> > news:caovo2$qcg$1@.ls219.htnet.hr...
> > > I have two database (structurly idenical) on the same SQL server,
first
> > > working good, but second is very slow
> > > (noticed from web aplication)
> > >
> > > I would like the same speed for both database
> >
> >
> > It is not so hard to make two databases equally slow just put "delay
for"
> in
> > key places...
> >
> >
>|||You should consider the physical file system... Are the databases loaded to
the same or equivalent disks using the same filegroups/files?
Have both of the databases been maintained ( indexdefrag and update
statistics.)
As one other poster mentioned... If you feel like the problem is in the
database, isolate one query which works more slowly in one db than the
other, and look at the query plan... If you can not isolate this to a
single query ( or a group of queries) it might not be a database problem.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"DS1979" <ds19792004@.yahoo.com> wrote in message
news:caovo2$qcg$1@.ls219.htnet.hr...
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>|||Out of curiousity have set a performance monitor for both
servers, it could be that one server is being used for a
lot more work than the other.
Other than that just follow what the guys have said.
J
>--Original Message--
>I have two database (structurly idenical) on the same SQL
server, first
>working good, but second is very slow
>(noticed from web aplication)
>I would like the same speed for both database
>is there any database parameters need to be set to make
same speed
>Thanks for your answer
>
>.
>|||DS1979,
You might want to compare that the databases are indeed identical using
a third party tool such as http://www.red-gate.com/SQL_Compare.htm or
look at http://www.aspfaq.com/show.asp?id=2209 for more options.
This will highlight any differences. Once you have confirmed they are
the same, update statistics and defrag indexes. Also check that the
databases are residing on the same disk subsystem by running sp_helpfile
in each db.
Use Profiler to check the worst performing queries, then look at the
execution plans of those queries - there could be indexing differences
between the databases.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
DS1979 wrote:
> I have two database (structurly idenical) on the same SQL server, first
> working good, but second is very slow
> (noticed from web aplication)
> I would like the same speed for both database
> is there any database parameters need to be set to make same speed
> Thanks for your answer
>|||Thanks, I think maybe I found problem
See this
I found someting new in this story,
I found that administrator did this
1) copy xxx.mdf and xxx_log.ldf from (copy from file system) server A to
server B
2) Make new database on server B
3) Change path in server B database >> properties >> Data file and
Transaction Log to server B\xxx.mdf and server B\xxx_log.ldf
4) Put database server B\ working
no_sp_detach, no sp_attach ?
What do you think is this main reason for slow working (faster database
didn't moved from orginal location and it's working good)
What is the best solution to repair this situation now ?
Thanks, again
"Wayne Snyder" <wayne.snyder@.mariner-usa.com> wrote in message
news:%23PMikB5UEHA.3428@.TK2MSFTNGP12.phx.gbl...
> You should consider the physical file system... Are the databases loaded
to
> the same or equivalent disks using the same filegroups/files?
> Have both of the databases been maintained ( indexdefrag and update
> statistics.)
> As one other poster mentioned... If you feel like the problem is in the
> database, isolate one query which works more slowly in one db than the
> other, and look at the query plan... If you can not isolate this to a
> single query ( or a group of queries) it might not be a database problem.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "DS1979" <ds19792004@.yahoo.com> wrote in message
> news:caovo2$qcg$1@.ls219.htnet.hr...
> > I have two database (structurly idenical) on the same SQL server, first
> > working good, but second is very slow
> > (noticed from web aplication)
> >
> > I would like the same speed for both database
> > is there any database parameters need to be set to make same speed
> >
> > Thanks for your answer
> >
> >
>
Wednesday, March 21, 2012
database server Link DOWN
Hi every body.
We have instaled Sql Server 2000 Standard Sp4, whit a Nortel Product. That aplication make to gestion calls using MSQL2000; in some moment the DB stoping and the Reason is "[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Arithmetic overflow error for data type smallint, value = 33459."
We do not have any idea about this problem.
Thx
Eliseo Berdugo
Hi, try to desinstal and reinstall your "Driver for JDBC".Friday, February 17, 2012
Database Performance
Hello there,
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco Pais
Usually the causes are bad design, poorly written queries, and
poor/inadequate indexing. BOL has a lot of trouble-shooting information
under the topic "Troubleshooting". You probably want to look at blocking
first.
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:ebcvgSTBFHA.3644@.TK2MSFTNGP15.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
SQL
> Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
> memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
think
> that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
|||There are lots of things it can be and you need to narrow down the
possibilities. Blocking does indeed sound like a good possibility. Try
running sp_who2 when you have multiple users in the slow state and see if
any show up with a spid in the Blcked by column. These articles should help
to get you going in the right direction.
http://www.microsoft.com/sql/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:ebcvgSTBFHA.3644@.TK2MSFTNGP15.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
> SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of
> RAM memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
> think that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco Pais
Usually the causes are bad design, poorly written queries, and
poor/inadequate indexing. BOL has a lot of trouble-shooting information
under the topic "Troubleshooting". You probably want to look at blocking
first.
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:ebcvgSTBFHA.3644@.TK2MSFTNGP15.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
SQL
> Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
> memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
think
> that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
|||There are lots of things it can be and you need to narrow down the
possibilities. Blocking does indeed sound like a good possibility. Try
running sp_who2 when you have multiple users in the slow state and see if
any show up with a spid in the Blcked by column. These articles should help
to get you going in the right direction.
http://www.microsoft.com/sql/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:ebcvgSTBFHA.3644@.TK2MSFTNGP15.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
> SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of
> RAM memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
> think that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
Database Performance
Hello there,
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco Pais
Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:u$%23YoSTBFHA.3592@.TK2MSFTNGP09.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
> SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of
> RAM memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
> think that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
|||Considering that the problem seems to occur as more users login, first read
up on:
sp_who2 and blocking SPIDs
transaction isolation level
To optimize the runtime of queries:
Analyzing Execution Plans
Also, go to msdn.com and search on "sql server" and "optimization"
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:u$%23YoSTBFHA.3592@.TK2MSFTNGP09.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
SQL
> Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
> memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
think
> that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco Pais
Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:u$%23YoSTBFHA.3592@.TK2MSFTNGP09.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
> SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of
> RAM memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
> think that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
|||Considering that the problem seems to occur as more users login, first read
up on:
sp_who2 and blocking SPIDs
transaction isolation level
To optimize the runtime of queries:
Analyzing Execution Plans
Also, go to msdn.com and search on "sql server" and "optimization"
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:u$%23YoSTBFHA.3592@.TK2MSFTNGP09.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
SQL
> Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
> memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
think
> that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
Database performance
Hello there,
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco Pais
Take a look here:
http://support.microsoft.com/default...b;en-us;224587
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
Yes it's very important, although it has nothing to do with
performance. If user applications connect as a system administrator
then security is non-existent - one rogue user, faulty piece of code or
malicious hack could destroy your database and your server.
David Portas
SQL Server MVP
|||"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:OVwy8STBFHA.2012@.TK2MSFTNGP15.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
SQL
> Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
> memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
This is almost certainly a code problem. It could be the application is
keeping locks for far longer than necessary. It could be your queries have
changed enough that your indices don't work as well.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
As David mentions, this is a HUGE security risk. Not only can users do
anything to the db, they can do anything to the OS.
With the XP_CMDSHELL command they can create domain users, add them to the
domain admin group and take over your system.
> What can I do to troubleshoot this problem?
Simplest, look at output of sp_who2 active and look for blocking. If it's
there consistently, that's your biggest problem. Eliminate it.
Use dbcc inputbuffer(spid) on the blocking spid to see what the code looks
like.
If this doesn't help, time to break out profiler.
> The are serveral important tables with many fields and many records. I
think
> that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco Pais
Take a look here:
http://support.microsoft.com/default...b;en-us;224587
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
Yes it's very important, although it has nothing to do with
performance. If user applications connect as a system administrator
then security is non-existent - one rogue user, faulty piece of code or
malicious hack could destroy your database and your server.
David Portas
SQL Server MVP
|||"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:OVwy8STBFHA.2012@.TK2MSFTNGP15.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
SQL
> Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
> memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
This is almost certainly a code problem. It could be the application is
keeping locks for far longer than necessary. It could be your queries have
changed enough that your indices don't work as well.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
As David mentions, this is a HUGE security risk. Not only can users do
anything to the db, they can do anything to the OS.
With the XP_CMDSHELL command they can create domain users, add them to the
domain admin group and take over your system.
> What can I do to troubleshoot this problem?
Simplest, look at output of sp_who2 active and look for blocking. If it's
there consistently, that's your biggest problem. Eliminate it.
Use dbcc inputbuffer(spid) on the blocking spid to see what the code looks
like.
If this doesn't help, time to break out profiler.
> The are serveral important tables with many fields and many records. I
think
> that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
Database Performance
Hello there,
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco PaisPlease don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:u$%23YoSTBFHA.3592@.TK2MSFTNGP09.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
> SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of
> RAM memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
> think that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>|||Considering that the problem seems to occur as more users login, first read
up on:
sp_who2 and blocking SPIDs
transaction isolation level
To optimize the runtime of queries:
Analyzing Execution Plans
Also, go to msdn.com and search on "sql server" and "optimization"
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:u$%23YoSTBFHA.3592@.TK2MSFTNGP09.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
SQL
> Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
> memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
think
> that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco PaisPlease don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.
Andrew J. Kelly SQL MVP
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:u$%23YoSTBFHA.3592@.TK2MSFTNGP09.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
> SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of
> RAM memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
> think that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>|||Considering that the problem seems to occur as more users login, first read
up on:
sp_who2 and blocking SPIDs
transaction isolation level
To optimize the runtime of queries:
Analyzing Execution Plans
Also, go to msdn.com and search on "sql server" and "optimization"
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:u$%23YoSTBFHA.3592@.TK2MSFTNGP09.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
SQL
> Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
> memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
think
> that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
Database performance
Hello there,
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco PaisTake a look here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224587
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
Yes it's very important, although it has nothing to do with
performance. If user applications connect as a system administrator
then security is non-existent - one rogue user, faulty piece of code or
malicious hack could destroy your database and your server.
--
David Portas
SQL Server MVP
--|||"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:OVwy8STBFHA.2012@.TK2MSFTNGP15.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
SQL
> Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
> memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
This is almost certainly a code problem. It could be the application is
keeping locks for far longer than necessary. It could be your queries have
changed enough that your indices don't work as well.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
As David mentions, this is a HUGE security risk. Not only can users do
anything to the db, they can do anything to the OS.
With the XP_CMDSHELL command they can create domain users, add them to the
domain admin group and take over your system.
> What can I do to troubleshoot this problem?
Simplest, look at output of sp_who2 active and look for blocking. If it's
there consistently, that's your biggest problem. Eliminate it.
Use dbcc inputbuffer(spid) on the blocking spid to see what the code looks
like.
If this doesn't help, time to break out profiler.
> The are serveral important tables with many fields and many records. I
think
> that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco PaisTake a look here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224587
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
Yes it's very important, although it has nothing to do with
performance. If user applications connect as a system administrator
then security is non-existent - one rogue user, faulty piece of code or
malicious hack could destroy your database and your server.
--
David Portas
SQL Server MVP
--|||"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:OVwy8STBFHA.2012@.TK2MSFTNGP15.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
SQL
> Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
> memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
This is almost certainly a code problem. It could be the application is
keeping locks for far longer than necessary. It could be your queries have
changed enough that your indices don't work as well.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
As David mentions, this is a HUGE security risk. Not only can users do
anything to the db, they can do anything to the OS.
With the XP_CMDSHELL command they can create domain users, add them to the
domain admin group and take over your system.
> What can I do to troubleshoot this problem?
Simplest, look at output of sp_who2 active and look for blocking. If it's
there consistently, that's your biggest problem. Eliminate it.
Use dbcc inputbuffer(spid) on the blocking spid to see what the code looks
like.
If this doesn't help, time to break out profiler.
> The are serveral important tables with many fields and many records. I
think
> that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
Database performance
Hello there,
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco Pais
Giving them "sa" access unless it is "absolutely" necessary
is just plain insane from a security perspective. However,
that doesn't address your problem.
Can you give us some guidance on whether you have
indexed your tables, how large they are, when was the
last time the hard drive was defragged, when was the
last time you reindexed the indexes.
There could be a ton of things that need to be addressed.
Sounds like you are a bit of a beginner to managing SQL
Server databases, these free flash video presentations might
help:
http://www.eggheadcafe.com/videodemo/
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:%23UPi1STBFHA.1656@.TK2MSFTNGP11.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
> SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of
> RAM memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
> think that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco Pais
Giving them "sa" access unless it is "absolutely" necessary
is just plain insane from a security perspective. However,
that doesn't address your problem.
Can you give us some guidance on whether you have
indexed your tables, how large they are, when was the
last time the hard drive was defragged, when was the
last time you reindexed the indexes.
There could be a ton of things that need to be addressed.
Sounds like you are a bit of a beginner to managing SQL
Server databases, these free flash video presentations might
help:
http://www.eggheadcafe.com/videodemo/
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:%23UPi1STBFHA.1656@.TK2MSFTNGP11.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
> SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of
> RAM memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
> think that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
Database performance
Hello there,
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco PaisGiving them "sa" access unless it is "absolutely" necessary
is just plain insane from a security perspective. However,
that doesn't address your problem.
Can you give us some guidance on whether you have
indexed your tables, how large they are, when was the
last time the hard drive was defragged, when was the
last time you reindexed the indexes.
There could be a ton of things that need to be addressed.
Sounds like you are a bit of a beginner to managing SQL
Server databases, these free flash video presentations might
help:
http://www.eggheadcafe.com/videodemo/
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:%23UPi1STBFHA.1656@.TK2MSFTNGP11.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
> SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of
> RAM memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
> think that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the aplication,
there picks when its almost impossible work normaly.
My question is: what can possible cause this loss of performance?
All workstations have an ODBC connection with 'sa' user. Can it be
important?
What can I do to troubleshoot this problem?
The are serveral important tables with many fields and many records. I think
that I have created indexes correctly.
Can anybody help me? Thanks.
Regards,
Marco PaisGiving them "sa" access unless it is "absolutely" necessary
is just plain insane from a security perspective. However,
that doesn't address your problem.
Can you give us some guidance on whether you have
indexed your tables, how large they are, when was the
last time the hard drive was defragged, when was the
last time you reindexed the indexes.
There could be a ton of things that need to be addressed.
Sounds like you are a bit of a beginner to managing SQL
Server databases, these free flash video presentations might
help:
http://www.eggheadcafe.com/videodemo/
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net
"Marco Pais" <mpaisIGNORE@.foruminformatica.pt> wrote in message
news:%23UPi1STBFHA.1656@.TK2MSFTNGP11.phx.gbl...
> Hello there,
> I am experiencing performance problems with an aplication running over a
> SQL Server 2000 Database. The server that holds SQL Server has 2.8 GB of
> RAM memory. When there are just on or two users working, the aplication
> performance is suportable, but when more users are using the aplication,
> there picks when its almost impossible work normaly.
> My question is: what can possible cause this loss of performance?
> All workstations have an ODBC connection with 'sa' user. Can it be
> important?
> What can I do to troubleshoot this problem?
> The are serveral important tables with many fields and many records. I
> think that I have created indexes correctly.
> Can anybody help me? Thanks.
> Regards,
> Marco Pais
>
Subscribe to:
Posts (Atom)