Hi, I have a web application which is taking a fair bit of traffic.
It involves a registration process, and then a series of questions which
must be answered. The SQL server receives upwards of 1,000,000 queries a
day.
Unfortunately on a small number of these queries (~500 a day), the ASP pages
are returning that the SQL server does not exist or that access if denied.
Having explored the Microsoft Support Site, and exhausted all possible
solutions, without actually reaching a solution - I was wondering - is it
possible that the server is actually just taking so many requests that it
can't be found? Surely this should return a timeout?
The web box is a Windows 2000 IIS installation, and the SQL box is a
separate Windows 2000 / SQL Server 2000 installation.
Anyone got any ideas?
Many thanks.
MattWhat are you using to handle connections -- TCP/IP sockets, named pipes or
both? I would double check your IIS server and SQL server to make sure the
server and client network utilities match up with connection parameters.
Have you tried using Performance Monitor on the SQL server? You will take a
small performance hit, but you can get some more information on what is
happening when the connection fails. You should probably start off
monitoring a few basic SQL counters -- like for reads, writes and
connections.
When a SQL connection can't be made, the SQL server does not exist or access
denied is actually a common error. In my line of support, it usually means
that a network connection (ipc$) between the client and server can't be
made, but I imagine this is not the case for you.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Matt Pallatt" <matt.pallatt@.bnm.co.uk> wrote in message
news:%23ZMUOpzQEHA.3124@.TK2MSFTNGP12.phx.gbl...
> Hi, I have a web application which is taking a fair bit of traffic.
> It involves a registration process, and then a series of questions which
> must be answered. The SQL server receives upwards of 1,000,000 queries a
> day.
> Unfortunately on a small number of these queries (~500 a day), the ASP
pages
> are returning that the SQL server does not exist or that access if denied.
> Having explored the Microsoft Support Site, and exhausted all possible
> solutions, without actually reaching a solution - I was wondering - is it
> possible that the server is actually just taking so many requests that it
> can't be found? Surely this should return a timeout?
> The web box is a Windows 2000 IIS installation, and the SQL box is a
> separate Windows 2000 / SQL Server 2000 installation.
> Anyone got any ideas?
> Many thanks.
> Matt
>|||So connection/session pooling should be in use for large web based
applications. If you've disabled connection/session pooling then this
would put a heavier burden on the server.
What is your connection Timeout value?
What is running on the server when the timeouts happen?
Is there any blocking?
How many web servers are connecting to the SQL Server?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||We were having the exact same problem. It seems that by stopping SQL Server
from listening on named pipes (ie. just leaving tcp/ip) stopped the problem|||Sorry, may have spoken too soon. Our error have come back.
Showing posts with label bit. Show all posts
Showing posts with label bit. Show all posts
Friday, March 30, 2012
Intermittent SQL Server does not exist or access denied.
Hi, I have a web application which is taking a fair bit of traffic.
It involves a registration process, and then a series of questions which
must be answered. The SQL server receives upwards of 1,000,000 queries a
day.
Unfortunately on a small number of these queries (~500 a day), the ASP pages
are returning that the SQL server does not exist or that access if denied.
Having explored the Microsoft Support Site, and exhausted all possible
solutions, without actually reaching a solution - I was wondering - is it
possible that the server is actually just taking so many requests that it
can't be found? Surely this should return a timeout?
The web box is a windows 2000 IIS installation, and the SQL box is a
separate Windows 2000 / SQL Server 2000 installation.
Anyone got any ideas?
Many thanks.
Matt
What are you using to handle connections -- TCP/IP sockets, named pipes or
both? I would double check your IIS server and SQL server to make sure the
server and client network utilities match up with connection parameters.
Have you tried using Performance Monitor on the SQL server? You will take a
small performance hit, but you can get some more information on what is
happening when the connection fails. You should probably start off
monitoring a few basic SQL counters -- like for reads, writes and
connections.
When a SQL connection can't be made, the SQL server does not exist or access
denied is actually a common error. In my line of support, it usually means
that a network connection (ipc$) between the client and server can't be
made, but I imagine this is not the case for you.
************************************************** *****************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
************************************************** *****************
"Matt Pallatt" <matt.pallatt@.bnm.co.uk> wrote in message
news:%23ZMUOpzQEHA.3124@.TK2MSFTNGP12.phx.gbl...
> Hi, I have a web application which is taking a fair bit of traffic.
> It involves a registration process, and then a series of questions which
> must be answered. The SQL server receives upwards of 1,000,000 queries a
> day.
> Unfortunately on a small number of these queries (~500 a day), the ASP
pages
> are returning that the SQL server does not exist or that access if denied.
> Having explored the Microsoft Support Site, and exhausted all possible
> solutions, without actually reaching a solution - I was wondering - is it
> possible that the server is actually just taking so many requests that it
> can't be found? Surely this should return a timeout?
> The web box is a windows 2000 IIS installation, and the SQL box is a
> separate Windows 2000 / SQL Server 2000 installation.
> Anyone got any ideas?
> Many thanks.
> Matt
>
|||So connection/session pooling should be in use for large web based
applications. If you've disabled connection/session pooling then this
would put a heavier burden on the server.
What is your connection Timeout value?
What is running on the server when the timeouts happen?
Is there any blocking?
How many web servers are connecting to the SQL Server?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||We were having the exact same problem. It seems that by stopping SQL
Server from listening on named pipes (ie. just leaving tcp/ip) stopped
the problem
chudles
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message245192.html
|||Sorry, may have spoken too soon. Our error have come back.
chudles
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message245192.html
It involves a registration process, and then a series of questions which
must be answered. The SQL server receives upwards of 1,000,000 queries a
day.
Unfortunately on a small number of these queries (~500 a day), the ASP pages
are returning that the SQL server does not exist or that access if denied.
Having explored the Microsoft Support Site, and exhausted all possible
solutions, without actually reaching a solution - I was wondering - is it
possible that the server is actually just taking so many requests that it
can't be found? Surely this should return a timeout?
The web box is a windows 2000 IIS installation, and the SQL box is a
separate Windows 2000 / SQL Server 2000 installation.
Anyone got any ideas?
Many thanks.
Matt
What are you using to handle connections -- TCP/IP sockets, named pipes or
both? I would double check your IIS server and SQL server to make sure the
server and client network utilities match up with connection parameters.
Have you tried using Performance Monitor on the SQL server? You will take a
small performance hit, but you can get some more information on what is
happening when the connection fails. You should probably start off
monitoring a few basic SQL counters -- like for reads, writes and
connections.
When a SQL connection can't be made, the SQL server does not exist or access
denied is actually a common error. In my line of support, it usually means
that a network connection (ipc$) between the client and server can't be
made, but I imagine this is not the case for you.
************************************************** *****************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
************************************************** *****************
"Matt Pallatt" <matt.pallatt@.bnm.co.uk> wrote in message
news:%23ZMUOpzQEHA.3124@.TK2MSFTNGP12.phx.gbl...
> Hi, I have a web application which is taking a fair bit of traffic.
> It involves a registration process, and then a series of questions which
> must be answered. The SQL server receives upwards of 1,000,000 queries a
> day.
> Unfortunately on a small number of these queries (~500 a day), the ASP
pages
> are returning that the SQL server does not exist or that access if denied.
> Having explored the Microsoft Support Site, and exhausted all possible
> solutions, without actually reaching a solution - I was wondering - is it
> possible that the server is actually just taking so many requests that it
> can't be found? Surely this should return a timeout?
> The web box is a windows 2000 IIS installation, and the SQL box is a
> separate Windows 2000 / SQL Server 2000 installation.
> Anyone got any ideas?
> Many thanks.
> Matt
>
|||So connection/session pooling should be in use for large web based
applications. If you've disabled connection/session pooling then this
would put a heavier burden on the server.
What is your connection Timeout value?
What is running on the server when the timeouts happen?
Is there any blocking?
How many web servers are connecting to the SQL Server?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||We were having the exact same problem. It seems that by stopping SQL
Server from listening on named pipes (ie. just leaving tcp/ip) stopped
the problem
chudles
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message245192.html
|||Sorry, may have spoken too soon. Our error have come back.
chudles
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message245192.html
Monday, March 12, 2012
Interaction with VB/VBA
Hi there,
I've just started learning SQL - I already know a bit of VB/VBA and my aim is to become a software developer using both SQL and VB.
One question I have is how would the average programmer go about managing the database? Are SQL commands (queries/add record/make table etc) normally programmed and controlled in VB itself via the docommand.runSQL on the event triggers or are they managed from the SQL Server application themselves? Also, if there are any other comments on how VB works with SQL I'd be very interested to hear them.
My assumption is that the database commands are managed from VB and any automated download/import or export of data into or from the SQL database is scheduled from SQL server itself.
Many thanks for your time in reading.If you use MS SQL Server 7 or 2000 you can use Enterprise Manager to manage your databases. If you use SQL Server 2005 then you can use SQL Server Management Studio to do the same.
You can connect to your SQL Server db from VB6 with ADO and with ADO.NET from VB.NET.|||Many thanks for your reply - how about if you're using MS Access for the front end?|||ADO works fine when using Access as a front end. Even better if you use an adp. You can use the majority of your VBA functions from access if you like. However, a wise developer ports the lionshare of their data-centric business logic to the database itself.|||Many thanks for your reply - how about if you're using MS Access for the front end?
If you use MS Access the only difference will be that you'll manage your data from the MS Access environment, but you will still use ADO and ADO.NET from your VB applications.|||If you are using SQL 2K and you are wise you will avoid Enterprise Manager and use Query Analyser. EM is a GUI, QA allows programmatic access to the database - much more powerful and much more flexible.
DBAs don't typically use Access or EM to manage a SQL Server db but YMMV depending on how much control you are looking for.
HTH|||If you are using SQL 2K and you are wise you will avoid Enterprise Manager and use Query Analyser. EM is a GUI, QA allows programmatic access to the database - much more powerful and much more flexible.
DBAs don't typically use Access or EM to manage a SQL Server db but YMMV depending on how much control you are looking for.
HTH
I use EM daily to run hand-built queries and I do have programmatic access to my databases. I use QA too, but for the most things EM is just fine.|||yeah but if you script everything, you are more efficient because all you have to do is it hit f5 and you have less hassles when sql goes to a new version and your ui changes.
I've just started learning SQL - I already know a bit of VB/VBA and my aim is to become a software developer using both SQL and VB.
One question I have is how would the average programmer go about managing the database? Are SQL commands (queries/add record/make table etc) normally programmed and controlled in VB itself via the docommand.runSQL on the event triggers or are they managed from the SQL Server application themselves? Also, if there are any other comments on how VB works with SQL I'd be very interested to hear them.
My assumption is that the database commands are managed from VB and any automated download/import or export of data into or from the SQL database is scheduled from SQL server itself.
Many thanks for your time in reading.If you use MS SQL Server 7 or 2000 you can use Enterprise Manager to manage your databases. If you use SQL Server 2005 then you can use SQL Server Management Studio to do the same.
You can connect to your SQL Server db from VB6 with ADO and with ADO.NET from VB.NET.|||Many thanks for your reply - how about if you're using MS Access for the front end?|||ADO works fine when using Access as a front end. Even better if you use an adp. You can use the majority of your VBA functions from access if you like. However, a wise developer ports the lionshare of their data-centric business logic to the database itself.|||Many thanks for your reply - how about if you're using MS Access for the front end?
If you use MS Access the only difference will be that you'll manage your data from the MS Access environment, but you will still use ADO and ADO.NET from your VB applications.|||If you are using SQL 2K and you are wise you will avoid Enterprise Manager and use Query Analyser. EM is a GUI, QA allows programmatic access to the database - much more powerful and much more flexible.
DBAs don't typically use Access or EM to manage a SQL Server db but YMMV depending on how much control you are looking for.
HTH|||If you are using SQL 2K and you are wise you will avoid Enterprise Manager and use Query Analyser. EM is a GUI, QA allows programmatic access to the database - much more powerful and much more flexible.
DBAs don't typically use Access or EM to manage a SQL Server db but YMMV depending on how much control you are looking for.
HTH
I use EM daily to run hand-built queries and I do have programmatic access to my databases. I use QA too, but for the most things EM is just fine.|||yeah but if you script everything, you are more efficient because all you have to do is it hit f5 and you have less hassles when sql goes to a new version and your ui changes.
Friday, March 9, 2012
Intel Hyper Threading
Hi
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
James
On our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>
|||Have a look here:
http://blogs.msdn.com/slavao/archive...12/492119.aspx
Markus
|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegr oups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archive...12/492119.aspx
> Markus
>
|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer is
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmark
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity to
> throw this away.
>
|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
James
On our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>
|||Have a look here:
http://blogs.msdn.com/slavao/archive...12/492119.aspx
Markus
|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegr oups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archive...12/492119.aspx
> Markus
>
|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer is
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmark
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity to
> throw this away.
>
|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:
Intel Hyper Threading
Hi
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
JamesOn our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>|||Have a look here:
http://blogs.msdn.com/slavao/archiv.../12/492119.aspx
Markus|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegroups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archiv.../12/492119.aspx
> Markus
>|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer i
s
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmar
k
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity
to
> throw this away.
>|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
JamesOn our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>|||Have a look here:
http://blogs.msdn.com/slavao/archiv.../12/492119.aspx
Markus|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegroups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archiv.../12/492119.aspx
> Markus
>|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer i
s
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmar
k
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity
to
> throw this away.
>|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:
Intel Hyper Threading
Hi
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
JamesOn our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>|||Have a look here:
http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx
Markus|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegroups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx
> Markus
>|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer is
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmark
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity to
> throw this away.
>|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:
>> <Excerpt>
>> So does it mean you have to disable HT when using SQL Server? The answer
>> is it really depends on the load and hardware you are using.
>> You have to test your application with HT on and off under heavy loads to
>> understand HT's implications.
>> </Excerpt>
>> There is no substitute for thorough performance testing when you have a
>> demanding application and/or expect to tax the hardware. I ran a
>> benchmark with our app on a 4-way (8 logical) proc server and we got
>> 15-20% percent improvement with HT enabled at the bios level. It would
>> have been a pity to throw this away.
Has anyone had any SQL performance issues when Hyper Threading is enabled on
BIOS? Do you have any comments regarding to HT?
I know this is a bit of a grey area for Citrix - but i have not seen any
comments about this for SQL
Regards
JamesOn our SQL boxes, we keep HT enabled and tweak the SQL Server max degree of
parallelism config option to specify no more than the number of processor
cores.
Every application is different so, if performance is important to you,
consider taking the time to run benchmarks with your application under
various configurations.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"James" <hushdontspamme@.hotmail.com> wrote in message
news:eU68yba9FHA.1148@.tk2msftngp13.phx.gbl...
> Hi
> Has anyone had any SQL performance issues when Hyper Threading is enabled
> on BIOS? Do you have any comments regarding to HT?
> I know this is a bit of a grey area for Citrix - but i have not seen any
> comments about this for SQL
> Regards
> James
>|||Have a look here:
http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx
Markus|||<Excerpt>
So does it mean you have to disable HT when using SQL Server? The answer is
it really depends on the load and hardware you are using.
You have to test your application with HT on and off under heavy loads to
understand HT's implications.
</Excerpt>
There is no substitute for thorough performance testing when you have a
demanding application and/or expect to tax the hardware. I ran a benchmark
with our app on a 4-way (8 logical) proc server and we got 15-20% percent
improvement with HT enabled at the bios level. It would have been a pity to
throw this away.
Hope this helps.
Dan Guzman
SQL Server MVP
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1133359063.147112.317730@.z14g2000cwz.googlegroups.com...
> Have a look here:
> http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx
> Markus
>|||Hi
Hi I wonder which tools (benchmarks) are you using to get the
performace infomation.
Thanks
Yoel
Dan Guzman wrote:
> <Excerpt>
> So does it mean you have to disable HT when using SQL Server? The answer is
> it really depends on the load and hardware you are using.
> You have to test your application with HT on and off under heavy loads to
> understand HT's implications.
> </Excerpt>
> There is no substitute for thorough performance testing when you have a
> demanding application and/or expect to tax the hardware. I ran a benchmark
> with our app on a 4-way (8 logical) proc server and we got 15-20% percent
> improvement with HT enabled at the bios level. It would have been a pity to
> throw this away.
>|||I performed a controlled test using our production application code and
data. The performance I reported was based on the actual elapsed time
difference. IMHO, this is the most meaningful type of test since the
objective is to optimize the server for production application processing.
Importantly, the application I tested was typical OLTP and highly optimized
with very few scans. Results could be different with an OLAP/reporting
application profile, a different OLTP application or different application
mix. I mentioned this when I posted to Slava's blog.
It can take considerable work to develop and run application benchmarks like
this. Such effort can be justified when you have demanding mission critical
applications that will fully tax your hardware but perhaps not justified
when hardware resources are less utilized. In my case, performance testing
and tuning was required anyway so that we could perform an application
migration in the shortest possible time.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Yoel Zumbado" <yzumbado@.hotmail.com> wrote in message
news:OK8Cfe0AGHA.3984@.TK2MSFTNGP14.phx.gbl...
> Hi
> Hi I wonder which tools (benchmarks) are you using to get the performace
> infomation.
> Thanks
> Yoel
> Dan Guzman wrote:
>> <Excerpt>
>> So does it mean you have to disable HT when using SQL Server? The answer
>> is it really depends on the load and hardware you are using.
>> You have to test your application with HT on and off under heavy loads to
>> understand HT's implications.
>> </Excerpt>
>> There is no substitute for thorough performance testing when you have a
>> demanding application and/or expect to tax the hardware. I ran a
>> benchmark with our app on a 4-way (8 logical) proc server and we got
>> 15-20% percent improvement with HT enabled at the bios level. It would
>> have been a pity to throw this away.
Friday, February 24, 2012
Integration service Express/2005
I finally bit the bullet and uninstalled all of Sql Server 2005 and installed Sql Server 2005 Express both Advanced and the Toolkit. I can get in and see everything locally and my production Great Plains server just fine through Management console. The one thing I can't do is open an integration package to process our credit cards.
It's a pretty simple integration, but when I go to open it in SQL Server Business Intelligence Development Studio, the only thing it shows installed was Reporting services, not Integration services. When I try to open the project it gives me:
"The application for project 'c:\pcard...' is not installed. Make sure the application for the project type(.dtproj) is installed."
I had a problem earlier with the gui not coming up but was resolved when I applied SS2005 SVP 2. Some items wasn't on the same version. I re-applied svp 2 after I installed SS express and still got the above. If I try and 'add' Integration Services, either thru Express or just regular ss2005, it says it's already installed.
Do I have to modify the registry so that it comes up on Business Intelligence Dev Studio? I can't run the integration if I can't open the project.
Hi Pete,
SQL Express does not include SSIS and the version of BIDS that installs with the Express Toolkit does not support opening SSIS packages. You will need to install one of the paid Editions of SQL Server 2005 to get SSIS functonality.
Mike
|||Hi Mike,
when you say Express Toolkit does not support opening SSIS packages, do you mean it does not support saving packages or the schedule package?
I want to know if there is any way I can save packages and do the scheduled jobs strictly without the licensed SQL Server.
thanks in advance.
Mike
|||hi Mike,
as Mike already pointed out, the BIDS version provided for SQLExpress does not allow you to open SSIS package..
BTW, SQLExpress does not provide the SQL Server Agent as well, so you can not even "schedule" package execution, and no "runtime" for SSIS is available.. you could, eventually, use DTS, as a runtime for it is provided at http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en
regards
|||Thanks Andrea...
I am still wrestling with SQL servers and I was wondering if you could give me a definite answer...
I am using enterprise manager to connect to SQL 2005 Express for snapshot replication. I've created new publications, and then using EXPRESS I created a local subscription to the publication.
But I could see no changes in my database.. Do you know why this is happening?
I tried to start the distribution agent (multiple publications) but some reason it can't connect to subscribers.
is this because 2000 and express can't connect to each other? or am I doing something wrong?
thanks
|||Hi ,
I understand that the BIDS version installed with SQL Express Toolkit does not allow to open the SSIS packages. Does that mean that we cannot even execute an SSIS package from SQL server Express.
Thanks.
Vigya
|||Hi Vigay,
Right, you can not use any part of SSIS in SQL Express, it isn't there. You can't run packages or anything else.
Mike
Integration service Express/2005
I finally bit the bullet and uninstalled all of Sql Server 2005 and installed Sql Server 2005 Express both Advanced and the Toolkit. I can get in and see everything locally and my production Great Plains server just fine through Management console. The one thing I can't do is open an integration package to process our credit cards.
It's a pretty simple integration, but when I go to open it in SQL Server Business Intelligence Development Studio, the only thing it shows installed was Reporting services, not Integration services. When I try to open the project it gives me:
"The application for project 'c:\pcard...' is not installed. Make sure the application for the project type(.dtproj) is installed."
I had a problem earlier with the gui not coming up but was resolved when I applied SS2005 SVP 2. Some items wasn't on the same version. I re-applied svp 2 after I installed SS express and still got the above. If I try and 'add' Integration Services, either thru Express or just regular ss2005, it says it's already installed.
Do I have to modify the registry so that it comes up on Business Intelligence Dev Studio? I can't run the integration if I can't open the project.
Hi Pete,
SQL Express does not include SSIS and the version of BIDS that installs with the Express Toolkit does not support opening SSIS packages. You will need to install one of the paid Editions of SQL Server 2005 to get SSIS functonality.
Mike
|||Hi Mike,
when you say Express Toolkit does not support opening SSIS packages, do you mean it does not support saving packages or the schedule package?
I want to know if there is any way I can save packages and do the scheduled jobs strictly without the licensed SQL Server.
thanks in advance.
Mike
|||hi Mike,
as Mike already pointed out, the BIDS version provided for SQLExpress does not allow you to open SSIS package..
BTW, SQLExpress does not provide the SQL Server Agent as well, so you can not even "schedule" package execution, and no "runtime" for SSIS is available.. you could, eventually, use DTS, as a runtime for it is provided at http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en
regards
|||Thanks Andrea...
I am still wrestling with SQL servers and I was wondering if you could give me a definite answer...
I am using enterprise manager to connect to SQL 2005 Express for snapshot replication. I've created new publications, and then using EXPRESS I created a local subscription to the publication.
But I could see no changes in my database.. Do you know why this is happening?
I tried to start the distribution agent (multiple publications) but some reason it can't connect to subscribers.
is this because 2000 and express can't connect to each other? or am I doing something wrong?
thanks
|||Hi ,
I understand that the BIDS version installed with SQL Express Toolkit does not allow to open the SSIS packages. Does that mean that we cannot even execute an SSIS package from SQL server Express.
Thanks.
Vigya
|||Hi Vigay,
Right, you can not use any part of SSIS in SQL Express, it isn't there. You can't run packages or anything else.
Mike
Integration service Express/2005
I finally bit the bullet and uninstalled all of Sql Server 2005 and installed Sql Server 2005 Express both Advanced and the Toolkit. I can get in and see everything locally and my production Great Plains server just fine through Management console. The one thing I can't do is open an integration package to process our credit cards.
It's a pretty simple integration, but when I go to open it in SQL Server Business Intelligence Development Studio, the only thing it shows installed was Reporting services, not Integration services. When I try to open the project it gives me:
"The application for project 'c:\pcard...' is not installed. Make sure the application for the project type(.dtproj) is installed."
I had a problem earlier with the gui not coming up but was resolved when I applied SS2005 SVP 2. Some items wasn't on the same version. I re-applied svp 2 after I installed SS express and still got the above. If I try and 'add' Integration Services, either thru Express or just regular ss2005, it says it's already installed.
Do I have to modify the registry so that it comes up on Business Intelligence Dev Studio? I can't run the integration if I can't open the project.
Hi Pete,
SQL Express does not include SSIS and the version of BIDS that installs with the Express Toolkit does not support opening SSIS packages. You will need to install one of the paid Editions of SQL Server 2005 to get SSIS functonality.
Mike
|||Hi Mike,
when you say Express Toolkit does not support opening SSIS packages, do you mean it does not support saving packages or the schedule package?
I want to know if there is any way I can save packages and do the scheduled jobs strictly without the licensed SQL Server.
thanks in advance.
Mike
|||hi Mike,
as Mike already pointed out, the BIDS version provided for SQLExpress does not allow you to open SSIS package..
BTW, SQLExpress does not provide the SQL Server Agent as well, so you can not even "schedule" package execution, and no "runtime" for SSIS is available.. you could, eventually, use DTS, as a runtime for it is provided at http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en
regards
|||Thanks Andrea...
I am still wrestling with SQL servers and I was wondering if you could give me a definite answer...
I am using enterprise manager to connect to SQL 2005 Express for snapshot replication. I've created new publications, and then using EXPRESS I created a local subscription to the publication.
But I could see no changes in my database.. Do you know why this is happening?
I tried to start the distribution agent (multiple publications) but some reason it can't connect to subscribers.
is this because 2000 and express can't connect to each other? or am I doing something wrong?
thanks
|||Hi ,
I understand that the BIDS version installed with SQL Express Toolkit does not allow to open the SSIS packages. Does that mean that we cannot even execute an SSIS package from SQL server Express.
Thanks.
Vigya
|||Hi Vigay,
Right, you can not use any part of SSIS in SQL Express, it isn't there. You can't run packages or anything else.
Mike
Integration service Express/2005
I finally bit the bullet and uninstalled all of Sql Server 2005 and installed Sql Server 2005 Express both Advanced and the Toolkit. I can get in and see everything locally and my production Great Plains server just fine through Management console. The one thing I can't do is open an integration package to process our credit cards.
It's a pretty simple integration, but when I go to open it in SQL Server Business Intelligence Development Studio, the only thing it shows installed was Reporting services, not Integration services. When I try to open the project it gives me:
"The application for project 'c:\pcard...' is not installed. Make sure the application for the project type(.dtproj) is installed."
I had a problem earlier with the gui not coming up but was resolved when I applied SS2005 SVP 2. Some items wasn't on the same version. I re-applied svp 2 after I installed SS express and still got the above. If I try and 'add' Integration Services, either thru Express or just regular ss2005, it says it's already installed.
Do I have to modify the registry so that it comes up on Business Intelligence Dev Studio? I can't run the integration if I can't open the project.
Hi Pete,
SQL Express does not include SSIS and the version of BIDS that installs with the Express Toolkit does not support opening SSIS packages. You will need to install one of the paid Editions of SQL Server 2005 to get SSIS functonality.
Mike
|||Hi Mike,
when you say Express Toolkit does not support opening SSIS packages, do you mean it does not support saving packages or the schedule package?
I want to know if there is any way I can save packages and do the scheduled jobs strictly without the licensed SQL Server.
thanks in advance.
Mike
|||hi Mike,
as Mike already pointed out, the BIDS version provided for SQLExpress does not allow you to open SSIS package..
BTW, SQLExpress does not provide the SQL Server Agent as well, so you can not even "schedule" package execution, and no "runtime" for SSIS is available.. you could, eventually, use DTS, as a runtime for it is provided at http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en
regards
|||Thanks Andrea...
I am still wrestling with SQL servers and I was wondering if you could give me a definite answer...
I am using enterprise manager to connect to SQL 2005 Express for snapshot replication. I've created new publications, and then using EXPRESS I created a local subscription to the publication.
But I could see no changes in my database.. Do you know why this is happening?
I tried to start the distribution agent (multiple publications) but some reason it can't connect to subscribers.
is this because 2000 and express can't connect to each other? or am I doing something wrong?
thanks
|||Hi ,
I understand that the BIDS version installed with SQL Express Toolkit does not allow to open the SSIS packages. Does that mean that we cannot even execute an SSIS package from SQL server Express.
Thanks.
Vigya
|||Hi Vigay,
Right, you can not use any part of SSIS in SQL Express, it isn't there. You can't run packages or anything else.
Mike
Integration service Express/2005
I finally bit the bullet and uninstalled all of Sql Server 2005 and installed Sql Server 2005 Express both Advanced and the Toolkit. I can get in and see everything locally and my production Great Plains server just fine through Management console. The one thing I can't do is open an integration package to process our credit cards.
It's a pretty simple integration, but when I go to open it in SQL Server Business Intelligence Development Studio, the only thing it shows installed was Reporting services, not Integration services. When I try to open the project it gives me:
"The application for project 'c:\pcard...' is not installed. Make sure the application for the project type(.dtproj) is installed."
I had a problem earlier with the gui not coming up but was resolved when I applied SS2005 SVP 2. Some items wasn't on the same version. I re-applied svp 2 after I installed SS express and still got the above. If I try and 'add' Integration Services, either thru Express or just regular ss2005, it says it's already installed.
Do I have to modify the registry so that it comes up on Business Intelligence Dev Studio? I can't run the integration if I can't open the project.
Hi Pete,
SQL Express does not include SSIS and the version of BIDS that installs with the Express Toolkit does not support opening SSIS packages. You will need to install one of the paid Editions of SQL Server 2005 to get SSIS functonality.
Mike
|||Hi Mike,
when you say Express Toolkit does not support opening SSIS packages, do you mean it does not support saving packages or the schedule package?
I want to know if there is any way I can save packages and do the scheduled jobs strictly without the licensed SQL Server.
thanks in advance.
Mike
|||hi Mike,
as Mike already pointed out, the BIDS version provided for SQLExpress does not allow you to open SSIS package..
BTW, SQLExpress does not provide the SQL Server Agent as well, so you can not even "schedule" package execution, and no "runtime" for SSIS is available.. you could, eventually, use DTS, as a runtime for it is provided at http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en
regards
|||Thanks Andrea...
I am still wrestling with SQL servers and I was wondering if you could give me a definite answer...
I am using enterprise manager to connect to SQL 2005 Express for snapshot replication. I've created new publications, and then using EXPRESS I created a local subscription to the publication.
But I could see no changes in my database.. Do you know why this is happening?
I tried to start the distribution agent (multiple publications) but some reason it can't connect to subscribers.
is this because 2000 and express can't connect to each other? or am I doing something wrong?
thanks
|||Hi ,
I understand that the BIDS version installed with SQL Express Toolkit does not allow to open the SSIS packages. Does that mean that we cannot even execute an SSIS package from SQL server Express.
Thanks.
Vigya
|||Hi Vigay,
Right, you can not use any part of SSIS in SQL Express, it isn't there. You can't run packages or anything else.
Mike
Subscribe to:
Posts (Atom)