Monitoring Impact of a User in SQL Server

Hi all,

Quick question. At my current job, we are looking to install an Access
frontend that connects to our main database. This would involve everyone
using the front-end to access the main SQL Server using a read-only user
account. The only concern is how this will affect performance.

Is there any quick way to profile and monitor if this is creating a big
drain on the database or if there is any problem in doing it this way?

Thanks a lot.
Iain
.

Relevant Pages

  • How to build a VAX/VMS emulator on Fedora Core 3 Linux
    ... make install the libpcap for ethernet support on VAX emulator ... Is the OpenVMS media ready to be mounted? ... * Do you want to install the MSGHLP database? ... Message from user AUDIT$SERVER on NEWBB ...
    (alt.os.linux.redhat)
  • Re: Splitting and networking database
    ... data on your company's PC and carry the front-end home to ... my client's network ... Use the wizard to split the database. ... Install the package on each of the computers which need to access the ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Distributing Runtime Only
    ... Or do I need to have a database ... Generally speaking, you would split your database into a frontend (forms, ... reports, queries, macros, and modules) and backend and distribute ... edition) to each, and install it. ...
    (microsoft.public.access.devtoolkits)
  • Re: Need technique to programatically update back end structure / relationships
    ... Yes, that should work, Bob. ... Install the new one. ... > have the user rename the current production database (after taking a ... > final step of the installation process, I would ask the user to execute ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Error: Cannot find a valid Windows XP Embedded database installed
    ... Both the database and tools are Eval or Retail? ... Microsoft Windows XP Embedded Test Team ... Well, in fact it has a network connection, and it's working without any ... if I install everything in the same computer (tools and ...
    (microsoft.public.windowsxp.embedded)