Application Role and SQL Express (2005)

Hello,

Can I confirm whether pooling=false in the connection string is still required for SQL Server 2005 (Express Edition)?

Various google searches say pooling has to be turned off for SQL Server 2000, but I was just wondering whether it is still a limitation for SQL Server 2005

Thanks

John

Hi,

could you please show of these link in google which point out that pooling should be disabled ? You can enable this for sure in SQL Server.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi,

Here's one

http://solidqualitylearning.com/Blogs/dejan/archive/2006/11/10/3487.aspx

I did say, "still required", but perhaps I should have made it clear that most google searches get to SQL Server 2000.

I am having problems with pooling on...

If pooling is off, I execute sp_setapprole after every time I do an Open.

I assume with pooling on, I should execute it just once, the first time I open for the same connection string.

Thanks

John

|||

http://msdn2.microsoft.com/en-us/8xx3tyca(VS.80).aspx & http://databases.aspfaq.com/database/how-do-i-enable-or-disable-connection-pooling.html

FYI.

|||

If you want to use pooling with application roles, then you should use sp_unsetapprole to unset the approle before returning the connection to the pool. If you cannot enforce this, then you should disable pooling when using application roles. This holds for both SQL Server and SQL Server Express.

Thanks
Laurentiu

Application Role and SQL Express (2005)

Hello,

Can I confirm whether pooling=false in the connection string is still required for SQL Server 2005 (Express Edition)?

Various google searches say pooling has to be turned off for SQL Server 2000, but I was just wondering whether it is still a limitation for SQL Server 2005

Thanks

John

Hi,

could you please show of these link in google which point out that pooling should be disabled ? You can enable this for sure in SQL Server.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi,

Here's one

http://solidqualitylearning.com/Blogs/dejan/archive/2006/11/10/3487.aspx

I did say, "still required", but perhaps I should have made it clear that most google searches get to SQL Server 2000.

I am having problems with pooling on...

If pooling is off, I execute sp_setapprole after every time I do an Open.

I assume with pooling on, I should execute it just once, the first time I open for the same connection string.

Thanks

John

|||

http://msdn2.microsoft.com/en-us/8xx3tyca(VS.80).aspx & http://databases.aspfaq.com/database/how-do-i-enable-or-disable-connection-pooling.html

FYI.

|||

If you want to use pooling with application roles, then you should use sp_unsetapprole to unset the approle before returning the connection to the pool. If you cannot enforce this, then you should disable pooling when using application roles. This holds for both SQL Server and SQL Server Express.

Thanks
Laurentiu

Application and database performance benchmarks

Hi
I need to develop and implement procedures to monitor performance of sql
server 2000/2005 databases and various applications. Is there a place where I
can look at for creating benchmarks .
Thanks
--
ontario, canadaChapter 1 of Inside Microsoft SQL Server 2004 Query Tuning and
Optimization has a section on creating a baseline for your workload,
and then monitoring the workload. That would be a reasonable place to
start to study the subject.
Roy Harvey
Beacon Falls, CT
On Fri, 25 Apr 2008 10:10:01 -0700, db <db@.discussions.microsoft.com>
wrote:
>Hi
>I need to develop and implement procedures to monitor performance of sql
>server 2000/2005 databases and various applications. Is there a place where I
>can look at for creating benchmarks .
>Thanks

Anyone Using 2005?

Since "The Release" 4 ws ago I've been monitoring the various Visual
Studio/.NET NGs to get a sampling of the issues people are running into. In
this SQL Server NG I don't see many questions at all about SQL Server 2005 -
issues, migration, etc... very little of anything 2005-specific... while
other groups (e.g., ASP.NET) have a fairly large percentage of 2005-specific
questions.
So my question... are any of you switching to SQL Server 2005? Or is the DBA
community, from your points of view, taking a wait and see approach? Or are
you all happily migrated with no issues? Or?
Thanks!Well it comes down to $$$.
My current client would like to upgrade to Visual Studio 2005 team suite and
SQL Server 2005 but MSDN Universal is no longer "universal" as Microsoft
wants an additional $1200 to obtain the Visual Studio team suite.
If the company is going to upgrade at all, it has to be team suite because
that has the integrated developer tools, testing, etc. An upgrade to Visual
Studio 2005 professional wouldn't provide enough of an upgrade to justify th
e
upgrade, retraining, retesting the entire Windows application (over 150
DLL's), upgrading all our clients to .NET Framework 2.0, upgrading
documentation, etc.
At this point, developers continue to request the upgrade but it falls on
deaf ears. Without team suite, we don't have enough ROI for a Windows
application.
Just my experience,
Joe
"Jeff" wrote:

> Since "The Release" 4 ws ago I've been monitoring the various Visual
> Studio/.NET NGs to get a sampling of the issues people are running into. I
n
> this SQL Server NG I don't see many questions at all about SQL Server 2005
-
> issues, migration, etc... very little of anything 2005-specific... while
> other groups (e.g., ASP.NET) have a fairly large percentage of 2005-specif
ic
> questions.
> So my question... are any of you switching to SQL Server 2005? Or is the D
BA
> community, from your points of view, taking a wait and see approach? Or ar
e
> you all happily migrated with no issues? Or?
> Thanks!
>
>|||Most of the questions here revolve around SQL queries, data modeling, etc.
and are not 2000 vs. 2005 specific.
"Jeff" <Jeff@.NoSpam.com> wrote in message
news:%23Urq4Wu%23FHA.3568@.TK2MSFTNGP09.phx.gbl...
> Since "The Release" 4 ws ago I've been monitoring the various Visual
> Studio/.NET NGs to get a sampling of the issues people are running into.
> In this SQL Server NG I don't see many questions at all about SQL Server
> 2005 - issues, migration, etc... very little of anything 2005-specific...
> while other groups (e.g., ASP.NET) have a fairly large percentage of
> 2005-specific questions.
> So my question... are any of you switching to SQL Server 2005? Or is the
> DBA community, from your points of view, taking a wait and see approach?
> Or are you all happily migrated with no issues? Or?
> Thanks!
>|||Yes - and that's why I asked! ... couldn't figure it out just from the
questions posted...
Anyone else using 2005?
"JT" <someone@.microsoft.com> wrote in message
news:uGHR1Lz%23FHA.984@.tk2msftngp13.phx.gbl...
> Most of the questions here revolve around SQL queries, data modeling, etc.
> and are not 2000 vs. 2005 specific.
> "Jeff" <Jeff@.NoSpam.com> wrote in message
> news:%23Urq4Wu%23FHA.3568@.TK2MSFTNGP09.phx.gbl...
>|||Yes, we have some serious Data Warehouses running on SQL Server 2005.
I know of 1 airline web reservation system that is running it already too.
There are 1'000's of installations out there running in production already.
Microsoft did a lot of pre-release training so the number of questions are
expected to be low.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jeff" <Jeff@.NoSpam.com> wrote in message
news:OCdgU65%23FHA.4088@.TK2MSFTNGP09.phx.gbl...
> Yes - and that's why I asked! ... couldn't figure it out just from the
> questions posted...
> Anyone else using 2005?
>
> "JT" <someone@.microsoft.com> wrote in message
> news:uGHR1Lz%23FHA.984@.tk2msftngp13.phx.gbl...
>|||Here you can find case studies of companies that have deployed SQL Server
2005.
http://www.microsoft.com/sql/prodin...es/default.mspx
"Jeff" <Jeff@.NoSpam.com> wrote in message
news:%23Urq4Wu%23FHA.3568@.TK2MSFTNGP09.phx.gbl...
> Since "The Release" 4 ws ago I've been monitoring the various Visual
> Studio/.NET NGs to get a sampling of the issues people are running into.
> In this SQL Server NG I don't see many questions at all about SQL Server
> 2005 - issues, migration, etc... very little of anything 2005-specific...
> while other groups (e.g., ASP.NET) have a fairly large percentage of
> 2005-specific questions.
> So my question... are any of you switching to SQL Server 2005? Or is the
> DBA community, from your points of view, taking a wait and see approach?
> Or are you all happily migrated with no issues? Or?
> Thanks!
>