If a database consists of more than one datafile, how does SQL Server use the space in these datafiles ?, does it fill up the first one then move to the next and so forth, or does it use up pages across all the files evenly ?.In a group, the files are all filled proportionnally to their size.
For example : a group with file1 = 100 MB and file2 = 200 MB
If you add 3 MB, 1 MB is added to file1, and 2 MB to file2.|||Thanks for the information|||You're welcome ! :)
Showing posts with label usage. Show all posts
Showing posts with label usage. Show all posts
Thursday, March 8, 2012
Tuesday, February 14, 2012
database usage
I have an application which uses a special login credential (username and
password) to access several sql databases.
Its installed on several clients. what's the best possible way to determine
what all databases the application connected to, at the end of the day from
SQL Server Side. ?
thxskg,
You did not tell us which interface are you using to connect to sql server.
In case you are using ADO or ADO.NET, you can setup the property "Applicatio
n
Name" in the connection string. Then you will be able to use sp_who2 or
sysprocesses and look for that value.
AMB
"skg" wrote:
> I have an application which uses a special login credential (username and
> password) to access several sql databases.
> Its installed on several clients. what's the best possible way to determin
e
> what all databases the application connected to, at the end of the day fro
m
> SQL Server Side. ?
> thx
>
>|||Thanks!!. I am using ado.net. The clients can close the application at the
end of the day.
In that case i will not be able to find out, which database.
What iam looking for is whethere there is a record whether a user logged in
a particular database today?
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:ED55575B-B66A-489A-8B3B-B2770446B696@.microsoft.com...
> skg,
> You did not tell us which interface are you using to connect to sql
> server.
> In case you are using ADO or ADO.NET, you can setup the property
> "Application
> Name" in the connection string. Then you will be able to use sp_who2 or
> sysprocesses and look for that value.
>
> AMB
> "skg" wrote:
>
password) to access several sql databases.
Its installed on several clients. what's the best possible way to determine
what all databases the application connected to, at the end of the day from
SQL Server Side. ?
thxskg,
You did not tell us which interface are you using to connect to sql server.
In case you are using ADO or ADO.NET, you can setup the property "Applicatio
n
Name" in the connection string. Then you will be able to use sp_who2 or
sysprocesses and look for that value.
AMB
"skg" wrote:
> I have an application which uses a special login credential (username and
> password) to access several sql databases.
> Its installed on several clients. what's the best possible way to determin
e
> what all databases the application connected to, at the end of the day fro
m
> SQL Server Side. ?
> thx
>
>|||Thanks!!. I am using ado.net. The clients can close the application at the
end of the day.
In that case i will not be able to find out, which database.
What iam looking for is whethere there is a record whether a user logged in
a particular database today?
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:ED55575B-B66A-489A-8B3B-B2770446B696@.microsoft.com...
> skg,
> You did not tell us which interface are you using to connect to sql
> server.
> In case you are using ADO or ADO.NET, you can setup the property
> "Application
> Name" in the connection string. Then you will be able to use sp_who2 or
> sysprocesses and look for that value.
>
> AMB
> "skg" wrote:
>
Subscribe to:
Posts (Atom)