Whats the limitations of data storage in sqlserver DB. How will be the perforamcne if i have database which will get a data of 400 GB per year and all the data should be there in the table the whole year and then it can be archived.according to ms you can continue to scale out and up if you use multiple servers clustered together with distributed partitioned views. more hardware. more sql liscenses. no problem. right.|||And the alternative is...? 32-way 32-bit cluster with a terabyte or 2 of RAM and the SAN of SAM. You gotta go up or out. I prefer out or both. I don't expect my software for free.
Read up on Google's technology. They can go out on 386 machines - discards. And as soon as people start discarding 1GHz machines, they'll switch to a real operating system.
Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts
Thursday, March 29, 2012
Sunday, March 25, 2012
Database Size Limitation of SQL Server 2000 Personal Edition ?
I would like to know is there any limitation to the size of data file of SQL
Server 2000 Personal Edition. Just like the MSDE, the data file size cannot
be greater than 2GB (From memory) ?No there is no limitation.
But there is limitation on RAM usage
Server 2000 Personal Edition. Just like the MSDE, the data file size cannot
be greater than 2GB (From memory) ?No there is no limitation.
But there is limitation on RAM usage
Database Size Limitation of SQL Server 2000 Personal Edition ?
I would like to know is there any limitation to the size of data file of SQL
Server 2000 Personal Edition. Just like the MSDE, the data file size cannot
be greater than 2GB (From memory) ?
No there is no limitation.
But there is limitation on RAM usage
Server 2000 Personal Edition. Just like the MSDE, the data file size cannot
be greater than 2GB (From memory) ?
No there is no limitation.
But there is limitation on RAM usage
Thursday, March 22, 2012
Database Size
I want how can i do to do capacity planning in sqlserver 2000.
Do you make scripts (vbs) who query the sysfiles tables and transfer the answer in excel ?
Please help me.
Philselect cast(sum(m.[size]) * 8 as nvarchar)+N'KB' AS DB_SIZE, cast(sum(l.[size]) * 8 as varchar)+N'KB' AS LOG_SIZE
from dbo.[sysfiles] m, dbo.[sysfiles] l
where m.[groupid] != 0
and l.[groupid] = 0|||Thanks for your answer, can i query other database server with this query ?|||[servername].[database].[dbo].[sysfiles]
where the server and database have been linked to the SQL Server you are running the query from
Do you make scripts (vbs) who query the sysfiles tables and transfer the answer in excel ?
Please help me.
Philselect cast(sum(m.[size]) * 8 as nvarchar)+N'KB' AS DB_SIZE, cast(sum(l.[size]) * 8 as varchar)+N'KB' AS LOG_SIZE
from dbo.[sysfiles] m, dbo.[sysfiles] l
where m.[groupid] != 0
and l.[groupid] = 0|||Thanks for your answer, can i query other database server with this query ?|||[servername].[database].[dbo].[sysfiles]
where the server and database have been linked to the SQL Server you are running the query from
Wednesday, March 21, 2012
database size
Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.replication:70959
hello all,
I have implemented a transactional replication (queued updating) that
creates a full replica of the main database. The size of the main db is 15GB
and the replicated db's size is 12GB. I would like to know why this
difference.
thank you,
peti
Peti,
a few questions:
are you replicating the complete database?
Are you comparing the actual size after taking account of shrinking etc?
Are the indexes contiguous?
Do you have exactly the same set of indexes?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thank you Paul,
Sorry for delay.
I have some answers for your questions:
The complete database is replicated and I shrunk all dbs before to compare.
I have the same set of indexes that are fragmented, I supose, because they
were never rebuilt.
Cheers,
peti
"Paul Ibison" wrote:
> Peti,
> a few questions:
> are you replicating the complete database?
> Are you comparing the actual size after taking account of shrinking etc?
> Are the indexes contiguous?
> Do you have exactly the same set of indexes?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
hello all,
I have implemented a transactional replication (queued updating) that
creates a full replica of the main database. The size of the main db is 15GB
and the replicated db's size is 12GB. I would like to know why this
difference.
thank you,
peti
Peti,
a few questions:
are you replicating the complete database?
Are you comparing the actual size after taking account of shrinking etc?
Are the indexes contiguous?
Do you have exactly the same set of indexes?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thank you Paul,
Sorry for delay.
I have some answers for your questions:
The complete database is replicated and I shrunk all dbs before to compare.
I have the same set of indexes that are fragmented, I supose, because they
were never rebuilt.
Cheers,
peti
"Paul Ibison" wrote:
> Peti,
> a few questions:
> are you replicating the complete database?
> Are you comparing the actual size after taking account of shrinking etc?
> Are the indexes contiguous?
> Do you have exactly the same set of indexes?
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
Database setup for backup and recovery
I am new to SQLServer but a DB2 DBA.
I want to be able to backup a specific table and restore it. Actually, i may want to backup/restore several tables - a sub-set of tables on the database.
I understand that backup-recovery is at a database level, not a table-file-filrgroup level. Therefore i have to backup-restore a database, but i only want a table.
How do sites handle this. Are many databases created based on backup recovery requirements.
If so, then how do developers know what database tables reside in - given that there are now many databases created to handle recovery requirements. A synonymns/alias/views added ?
tia
glenn
If you put the table on its own filegroup, you can restore just that filegroup/table. Else, you will need to restore the database to a staging db and copy/transfer the table from the staging db to the real db.|||Can i restore a single filegroup to a previous point in time (say 8am), but keep the rest of the database unchanged (say 10am).
Or, does the whole database have to be at the same point in time after a restore?
tia
Database setup for backup and recovery
I am new to SQLServer but a DB2 DBA.
I want to be able to backup a specific table and restore it. Actually, i may want to backup/restore several tables - a sub-set of tables on the database.
I understand that backup-recovery is at a database level, not a table-file-filrgroup level. Therefore i have to backup-restore a database, but i only want a table.
How do sites handle this. Are many databases created based on backup recovery requirements.
If so, then how do developers know what database tables reside in - given that there are now many databases created to handle recovery requirements. A synonymns/alias/views added ?
tia
glenn
If you put the table on its own filegroup, you can restore just that filegroup/table. Else, you will need to restore the database to a staging db and copy/transfer the table from the staging db to the real db.|||Can i restore a single filegroup to a previous point in time (say 8am), but keep the rest of the database unchanged (say 10am).
Or, does the whole database have to be at the same point in time after a restore?
tia
Monday, March 19, 2012
Database server connection
I am trying to using sqlserver as back-end for an application(web) running
on the window 2X, one thing I am not sure is that once I establish the
connection between database server and application, should I keep this
connection open while application is running, or only open it when
there is a requet to qury records from database?
on the window 2X, one thing I am not sure is that once I establish the
connection between database server and application, should I keep this
connection open while application is running, or only open it when
there is a requet to qury records from database?
Thanks for your help."Leon" <penghao98@.hotmail.com> wrote in message
news:89a0a7de.0409221926.6c394129@.posting.google.c om...
>I am trying to using sqlserver as back-end for an application(web) running
> on the window 2X, one thing I am not sure is that once I establish the
> connection between database server and application, should I keep this
> connection open while application is running, or only open it when
> there is a requet to qury records from database?
> Thanks for your help.
I believe the usual approach is to leave the connection open, to avoid the
overhead associated with opening and closing the connection again and again.
This is one reason for using connection pooling, for example.
You might want to post in a forum for your client library (eg ADO, JDBC) or
development environment (eg ASP, PHP) to see if there are any specific
considerations for your application.
Simon|||penghao98@.hotmail.com (Leon) wrote in message news:<89a0a7de.0409221926.6c394129@.posting.google.com>...
> I am trying to using sqlserver as back-end for an application(web) running
> on the window 2X, one thing I am not sure is that once I establish the
> connection between database server and application, should I keep this
> connection open while application is running, or only open it when
> there is a requet to qury records from database?
> Thanks for your help.
Hi,
This is question basically regarding connection pooling.
Which technology you are using for database acess? like ADO,JDO, JDBc
etc..?
In all these you can create a pool of connections and maintain it. So
the best thing which I feel is ,during boot up of your application
create a pool of connections, store it and use the connection when
needed.
This is purely dependent on your application also.
Some technologies like ADO and JDBC now support disconnected rowsets
also like CachedRowset in Java where internally it will(means
driver/proider) handle reconnecting to the server when a request
comes.
But from performance point of view, better to create connections
during start up.
How many connections? etc depending on the usage of your application
Regards
Zunil
Cordys
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 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)