Showing posts with label learn. Show all posts
Showing posts with label learn. Show all posts
Sunday, March 25, 2012
Access database change to SQL Server
I designed a database that works well in Access and I want to get it to run in SQL Server. How do I learn how and what to do to change over to SQL Server?First thing I'd recommend is to go to http://www.microsoft.com/sql and download the most recent copy of SQL Server Books Online. From there you should have enough information to plan your migration.
Access connection count at the same time
I want to learn access connection gives how many user to connect at the same time.
http://www.narcv.com/
Access is mainly limited through the performance of the server, the logical limit is AFAICR 32767, but in most cases you will be throttled through the physical limitations of the server. if you have conneciton pooling on the client side enabled, and you will go through the pool, you will be limited on the client side to the numbers of connections specified for the pool.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Sunday, March 11, 2012
Acceptable Performance Counter ranges
I am having some performance issues with end users and the SQL Server. I'm not a SQL Server admin, but I want to learn how to use performance counters to monitor the SQL Server. I've been scouring the net trying to find performance counter information.
I have found alot of places that define each performance counter, but I have run across relatively few sites that contain acceptable values for the various different performance counters. For example, I've been to extremeexperts.com and found their arti
cle "Understanding SQL Performance Counters." And for example it explains : "SQLSERVER:Access Methods - Full Scans/sec - Value greater than 1 or 2 indicates that we are having table/index page scans. We need to analyze how this can be avoided." I'm loo
king for information like the above where it said "Value greater than 1 or 2 ..." Does anyone know where I can get a full list of acceptable performance counter ranges?
Not sure if these have what your looking for but they are worth looking
over.
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
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:7450EA3C-549E-4EAB-9E46-D9CA956DF35A@.microsoft.com...
> I am having some performance issues with end users and the SQL Server.
I'm not a SQL Server admin, but I want to learn how to use performance
counters to monitor the SQL Server. I've been scouring the net trying to
find performance counter information. I have found alot of places that
define each performance counter, but I have run across relatively few sites
that contain acceptable values for the various different performance
counters. For example, I've been to extremeexperts.com and found their
article "Understanding SQL Performance Counters." And for example it
explains : "SQLSERVER:Access Methods - Full Scans/sec - Value greater than 1
or 2 indicates that we are having table/index page scans. We need to
analyze how this can be avoided." I'm looking for information like the
above where it said "Value greater than 1 or 2 ..." Does anyone know where
I can get a full list of acceptable performance counter ranges?
I have found alot of places that define each performance counter, but I have run across relatively few sites that contain acceptable values for the various different performance counters. For example, I've been to extremeexperts.com and found their arti
cle "Understanding SQL Performance Counters." And for example it explains : "SQLSERVER:Access Methods - Full Scans/sec - Value greater than 1 or 2 indicates that we are having table/index page scans. We need to analyze how this can be avoided." I'm loo
king for information like the above where it said "Value greater than 1 or 2 ..." Does anyone know where I can get a full list of acceptable performance counter ranges?
Not sure if these have what your looking for but they are worth looking
over.
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
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:7450EA3C-549E-4EAB-9E46-D9CA956DF35A@.microsoft.com...
> I am having some performance issues with end users and the SQL Server.
I'm not a SQL Server admin, but I want to learn how to use performance
counters to monitor the SQL Server. I've been scouring the net trying to
find performance counter information. I have found alot of places that
define each performance counter, but I have run across relatively few sites
that contain acceptable values for the various different performance
counters. For example, I've been to extremeexperts.com and found their
article "Understanding SQL Performance Counters." And for example it
explains : "SQLSERVER:Access Methods - Full Scans/sec - Value greater than 1
or 2 indicates that we are having table/index page scans. We need to
analyze how this can be avoided." I'm looking for information like the
above where it said "Value greater than 1 or 2 ..." Does anyone know where
I can get a full list of acceptable performance counter ranges?
Acceptable Performance Counter ranges
I am having some performance issues with end users and the SQL Server. I'm
not a SQL Server admin, but I want to learn how to use performance counters
to monitor the SQL Server. I've been scouring the net trying to find perfor
mance counter information.
I have found alot of places that define each performance counter, but I have
run across relatively few sites that contain acceptable values for the vari
ous different performance counters. For example, I've been to extremeexpert
s.com and found their arti
cle "Understanding SQL Performance Counters." And for example it explains :
"SQLSERVER:Access Methods - Full Scans/sec - Value greater than 1 or 2 indi
cates that we are having table/index page scans. We need to analyze how thi
s can be avoided." I'm loo
king for information like the above where it said "Value greater than 1 or 2
..." Does anyone know where I can get a full list of acceptable performanc
e counter ranges?Not sure if these have what your looking for but they are worth looking
over.
http://www.microsoft.com/sql/techin.../perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c...mance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
on_24u1.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
on_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:7450EA3C-549E-4EAB-9E46-D9CA956DF35A@.microsoft.com...
> I am having some performance issues with end users and the SQL Server.
I'm not a SQL Server admin, but I want to learn how to use performance
counters to monitor the SQL Server. I've been scouring the net trying to
find performance counter information. I have found alot of places that
define each performance counter, but I have run across relatively few sites
that contain acceptable values for the various different performance
counters. For example, I've been to extremeexperts.com and found their
article "Understanding SQL Performance Counters." And for example it
explains : "SQLSERVER:Access Methods - Full Scans/sec - Value greater than 1
or 2 indicates that we are having table/index page scans. We need to
analyze how this can be avoided." I'm looking for information like the
above where it said "Value greater than 1 or 2 ..." Does anyone know where
I can get a full list of acceptable performance counter ranges?
not a SQL Server admin, but I want to learn how to use performance counters
to monitor the SQL Server. I've been scouring the net trying to find perfor
mance counter information.
I have found alot of places that define each performance counter, but I have
run across relatively few sites that contain acceptable values for the vari
ous different performance counters. For example, I've been to extremeexpert
s.com and found their arti
cle "Understanding SQL Performance Counters." And for example it explains :
"SQLSERVER:Access Methods - Full Scans/sec - Value greater than 1 or 2 indi
cates that we are having table/index page scans. We need to analyze how thi
s can be avoided." I'm loo
king for information like the above where it said "Value greater than 1 or 2
..." Does anyone know where I can get a full list of acceptable performanc
e counter ranges?Not sure if these have what your looking for but they are worth looking
over.
http://www.microsoft.com/sql/techin.../perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c...mance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
on_24u1.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
on_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:7450EA3C-549E-4EAB-9E46-D9CA956DF35A@.microsoft.com...
> I am having some performance issues with end users and the SQL Server.
I'm not a SQL Server admin, but I want to learn how to use performance
counters to monitor the SQL Server. I've been scouring the net trying to
find performance counter information. I have found alot of places that
define each performance counter, but I have run across relatively few sites
that contain acceptable values for the various different performance
counters. For example, I've been to extremeexperts.com and found their
article "Understanding SQL Performance Counters." And for example it
explains : "SQLSERVER:Access Methods - Full Scans/sec - Value greater than 1
or 2 indicates that we are having table/index page scans. We need to
analyze how this can be avoided." I'm looking for information like the
above where it said "Value greater than 1 or 2 ..." Does anyone know where
I can get a full list of acceptable performance counter ranges?
Acceptable Performance Counter ranges
I am having some performance issues with end users and the SQL Server. I'm not a SQL Server admin, but I want to learn how to use performance counters to monitor the SQL Server. I've been scouring the net trying to find performance counter information. I have found alot of places that define each performance counter, but I have run across relatively few sites that contain acceptable values for the various different performance counters. For example, I've been to extremeexperts.com and found their article "Understanding SQL Performance Counters." And for example it explains : "SQLSERVER:Access Methods - Full Scans/sec - Value greater than 1 or 2 indicates that we are having table/index page scans. We need to analyze how this can be avoided." I'm looking for information like the above where it said "Value greater than 1 or 2 ..." Does anyone know where I can get a full list of acceptable performance counter ranges?Not sure if these have what your looking for but they are worth looking
over.
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:7450EA3C-549E-4EAB-9E46-D9CA956DF35A@.microsoft.com...
> I am having some performance issues with end users and the SQL Server.
I'm not a SQL Server admin, but I want to learn how to use performance
counters to monitor the SQL Server. I've been scouring the net trying to
find performance counter information. I have found alot of places that
define each performance counter, but I have run across relatively few sites
that contain acceptable values for the various different performance
counters. For example, I've been to extremeexperts.com and found their
article "Understanding SQL Performance Counters." And for example it
explains : "SQLSERVER:Access Methods - Full Scans/sec - Value greater than 1
or 2 indicates that we are having table/index page scans. We need to
analyze how this can be avoided." I'm looking for information like the
above where it said "Value greater than 1 or 2 ..." Does anyone know where
I can get a full list of acceptable performance counter ranges?
over.
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:7450EA3C-549E-4EAB-9E46-D9CA956DF35A@.microsoft.com...
> I am having some performance issues with end users and the SQL Server.
I'm not a SQL Server admin, but I want to learn how to use performance
counters to monitor the SQL Server. I've been scouring the net trying to
find performance counter information. I have found alot of places that
define each performance counter, but I have run across relatively few sites
that contain acceptable values for the various different performance
counters. For example, I've been to extremeexperts.com and found their
article "Understanding SQL Performance Counters." And for example it
explains : "SQLSERVER:Access Methods - Full Scans/sec - Value greater than 1
or 2 indicates that we are having table/index page scans. We need to
analyze how this can be avoided." I'm looking for information like the
above where it said "Value greater than 1 or 2 ..." Does anyone know where
I can get a full list of acceptable performance counter ranges?
Subscribe to:
Comments (Atom)