When you execute several long duration queries simultaneous on the SQL
server, is it then possible to give the execution of one query a higher or
lower priority than another query?
Hi,
As far as I know no. The only priority that could be set deals with how the
query behave in case of deadlocking. see DEADLOCK_PRIORITY in BOL.
Lionel
"pehuan" wrote:
> When you execute several long duration queries simultaneous on the SQL
> server, is it then possible to give the execution of one query a higher or
> lower priority than another query?
|||You can set the maximum degree of parallelism (the number of processors to
use) for a query on a multi processor machine, using OPTION (MAXDOP n). This
doesn't really set priority directly, but it gives you influence over the
amount of resources each query can use.
Jacco Schalkwijk
SQL Server MVP
"pehuan" <pehuan@.discussions.microsoft.com> wrote in message
news:29D00740-2821-4995-9312-11E3E5AA8207@.microsoft.com...
> When you execute several long duration queries simultaneous on the SQL
> server, is it then possible to give the execution of one query a higher or
> lower priority than another query?
|||There is no need for priority on SQL Server worker threads because SQL
Server does not use preemptive multi-tasking; it uses the cooperative
multi-tasking of the Win 3.0 days. UMS contexts yield as required, unless,
of corse, there is some sort of error.
Sincerely,
Anthony Thomas
"pehuan" <pehuan@.discussions.microsoft.com> wrote in message
news:29D00740-2821-4995-9312-11E3E5AA8207@.microsoft.com...
When you execute several long duration queries simultaneous on the SQL
server, is it then possible to give the execution of one query a higher or
lower priority than another query?
Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts
Wednesday, March 21, 2012
Query execution priority
When you execute several long duration queries simultaneous on the SQL
server, is it then possible to give the execution of one query a higher or
lower priority than another query?Hi,
As far as I know no. The only priority that could be set deals with how the
query behave in case of deadlocking. see DEADLOCK_PRIORITY in BOL.
Lionel
"pehuan" wrote:
> When you execute several long duration queries simultaneous on the SQL
> server, is it then possible to give the execution of one query a higher or
> lower priority than another query?|||You can set the maximum degree of parallelism (the number of processors to
use) for a query on a multi processor machine, using OPTION (MAXDOP n). This
doesn't really set priority directly, but it gives you influence over the
amount of resources each query can use.
Jacco Schalkwijk
SQL Server MVP
"pehuan" <pehuan@.discussions.microsoft.com> wrote in message
news:29D00740-2821-4995-9312-11E3E5AA8207@.microsoft.com...
> When you execute several long duration queries simultaneous on the SQL
> server, is it then possible to give the execution of one query a higher or
> lower priority than another query?|||There is no need for priority on SQL Server worker threads because SQL
Server does not use preemptive multi-tasking; it uses the cooperative
multi-tasking of the Win 3.0 days. UMS contexts yield as required, unless,
of corse, there is some sort of error.
Sincerely,
Anthony Thomas
"pehuan" <pehuan@.discussions.microsoft.com> wrote in message
news:29D00740-2821-4995-9312-11E3E5AA8207@.microsoft.com...
When you execute several long duration queries simultaneous on the SQL
server, is it then possible to give the execution of one query a higher or
lower priority than another query?sql
server, is it then possible to give the execution of one query a higher or
lower priority than another query?Hi,
As far as I know no. The only priority that could be set deals with how the
query behave in case of deadlocking. see DEADLOCK_PRIORITY in BOL.
Lionel
"pehuan" wrote:
> When you execute several long duration queries simultaneous on the SQL
> server, is it then possible to give the execution of one query a higher or
> lower priority than another query?|||You can set the maximum degree of parallelism (the number of processors to
use) for a query on a multi processor machine, using OPTION (MAXDOP n). This
doesn't really set priority directly, but it gives you influence over the
amount of resources each query can use.
Jacco Schalkwijk
SQL Server MVP
"pehuan" <pehuan@.discussions.microsoft.com> wrote in message
news:29D00740-2821-4995-9312-11E3E5AA8207@.microsoft.com...
> When you execute several long duration queries simultaneous on the SQL
> server, is it then possible to give the execution of one query a higher or
> lower priority than another query?|||There is no need for priority on SQL Server worker threads because SQL
Server does not use preemptive multi-tasking; it uses the cooperative
multi-tasking of the Win 3.0 days. UMS contexts yield as required, unless,
of corse, there is some sort of error.
Sincerely,
Anthony Thomas
"pehuan" <pehuan@.discussions.microsoft.com> wrote in message
news:29D00740-2821-4995-9312-11E3E5AA8207@.microsoft.com...
When you execute several long duration queries simultaneous on the SQL
server, is it then possible to give the execution of one query a higher or
lower priority than another query?sql
Tuesday, March 20, 2012
Query execution history?
Any chance to get this feature in SSMS?
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124530
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125147
Also nice blog post about it: http://sqlblogcasts.com/blogs/jonsayce/archive/2007/09/01/recent-queries.aspx
hi!
try this add-in for SSMS that provides the functionality
http://weblogs.sqlteam.com/mladenp/archive/2007/09/20/SSMS-Tools-Packan-add-in-for-SQL-Management-Studio.aspx
|||As for the drop-down with a list of columns in a table, that is being added as part of T-SQL Intellisense feature. First part of this functionality will be available in the upcoming CTP.
Regards,
Maciek Sarnowicz
Saturday, February 25, 2012
Query Builder Tool
Hello -- does anyone know of any good tools to create queries for SQL
Server? I'm currently using Query Analzyer, but would like something a bit
more QUI oriented similar to what Access has -- where I can insert tables
and drag columns, etc.
Any help would be appreciated.
Hello DavidM.
You can use Enterprise Manager for an interface very similar to Access.
Click the tables node to get a listing of all the tables in the right pane.
Select a table and right click. Select open table from the pop up menu.
Select Query. You should now see an interface like Access that you can use to
design queries.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"DavidM" wrote:
> Hello -- does anyone know of any good tools to create queries for SQL
> Server? I'm currently using Query Analzyer, but would like something a bit
> more QUI oriented similar to what Access has -- where I can insert tables
> and drag columns, etc.
> Any help would be appreciated.
>
>
|||Probably the best (and easiest) one I've seen is Crystal Reports.
Regards,
Hank Arnold
"DavidM" <spam@.spam.net> wrote in message
news:OoefkbD$EHA.3908@.TK2MSFTNGP12.phx.gbl...
> Hello -- does anyone know of any good tools to create queries for SQL
> Server? I'm currently using Query Analzyer, but would like something a
> bit more QUI oriented similar to what Access has -- where I can insert
> tables and drag columns, etc.
> Any help would be appreciated.
>
>
|||This one seems nice --
http://www.sqlmanager.net/products/mssql/query
"Hank Arnold" <rasilon@.aol.com> wrote in message
news:351eeqF4fnrjtU1@.individual.net...
> Probably the best (and easiest) one I've seen is Crystal Reports.
> --
> Regards,
> Hank Arnold
> "DavidM" <spam@.spam.net> wrote in message
> news:OoefkbD$EHA.3908@.TK2MSFTNGP12.phx.gbl...
>
Server? I'm currently using Query Analzyer, but would like something a bit
more QUI oriented similar to what Access has -- where I can insert tables
and drag columns, etc.
Any help would be appreciated.
Hello DavidM.
You can use Enterprise Manager for an interface very similar to Access.
Click the tables node to get a listing of all the tables in the right pane.
Select a table and right click. Select open table from the pop up menu.
Select Query. You should now see an interface like Access that you can use to
design queries.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"DavidM" wrote:
> Hello -- does anyone know of any good tools to create queries for SQL
> Server? I'm currently using Query Analzyer, but would like something a bit
> more QUI oriented similar to what Access has -- where I can insert tables
> and drag columns, etc.
> Any help would be appreciated.
>
>
|||Probably the best (and easiest) one I've seen is Crystal Reports.
Regards,
Hank Arnold
"DavidM" <spam@.spam.net> wrote in message
news:OoefkbD$EHA.3908@.TK2MSFTNGP12.phx.gbl...
> Hello -- does anyone know of any good tools to create queries for SQL
> Server? I'm currently using Query Analzyer, but would like something a
> bit more QUI oriented similar to what Access has -- where I can insert
> tables and drag columns, etc.
> Any help would be appreciated.
>
>
|||This one seems nice --
http://www.sqlmanager.net/products/mssql/query
"Hank Arnold" <rasilon@.aol.com> wrote in message
news:351eeqF4fnrjtU1@.individual.net...
> Probably the best (and easiest) one I've seen is Crystal Reports.
> --
> Regards,
> Hank Arnold
> "DavidM" <spam@.spam.net> wrote in message
> news:OoefkbD$EHA.3908@.TK2MSFTNGP12.phx.gbl...
>
Query Builder Tool
Hello -- does anyone know of any good tools to create queries for SQL
Server? I'm currently using Query Analzyer, but would like something a bit
more QUI oriented similar to what Access has -- where I can insert tables
and drag columns, etc.
Any help would be appreciated.Hello DavidM.
You can use Enterprise Manager for an interface very similar to Access.
Click the tables node to get a listing of all the tables in the right pane.
Select a table and right click. Select open table from the pop up menu.
Select Query. You should now see an interface like Access that you can use t
o
design queries.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"DavidM" wrote:
> Hello -- does anyone know of any good tools to create queries for SQL
> Server? I'm currently using Query Analzyer, but would like something a bi
t
> more QUI oriented similar to what Access has -- where I can insert tables
> and drag columns, etc.
> Any help would be appreciated.
>
>|||Probably the best (and easiest) one I've seen is Crystal Reports.
Regards,
Hank Arnold
"DavidM" <spam@.spam.net> wrote in message
news:OoefkbD$EHA.3908@.TK2MSFTNGP12.phx.gbl...
> Hello -- does anyone know of any good tools to create queries for SQL
> Server? I'm currently using Query Analzyer, but would like something a
> bit more QUI oriented similar to what Access has -- where I can insert
> tables and drag columns, etc.
> Any help would be appreciated.
>
>|||This one seems nice --
http://www.sqlmanager.net/products/mssql/query
"Hank Arnold" <rasilon@.aol.com> wrote in message
news:351eeqF4fnrjtU1@.individual.net...
> Probably the best (and easiest) one I've seen is Crystal Reports.
> --
> Regards,
> Hank Arnold
> "DavidM" <spam@.spam.net> wrote in message
> news:OoefkbD$EHA.3908@.TK2MSFTNGP12.phx.gbl...
>
Server? I'm currently using Query Analzyer, but would like something a bit
more QUI oriented similar to what Access has -- where I can insert tables
and drag columns, etc.
Any help would be appreciated.Hello DavidM.
You can use Enterprise Manager for an interface very similar to Access.
Click the tables node to get a listing of all the tables in the right pane.
Select a table and right click. Select open table from the pop up menu.
Select Query. You should now see an interface like Access that you can use t
o
design queries.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"DavidM" wrote:
> Hello -- does anyone know of any good tools to create queries for SQL
> Server? I'm currently using Query Analzyer, but would like something a bi
t
> more QUI oriented similar to what Access has -- where I can insert tables
> and drag columns, etc.
> Any help would be appreciated.
>
>|||Probably the best (and easiest) one I've seen is Crystal Reports.
Regards,
Hank Arnold
"DavidM" <spam@.spam.net> wrote in message
news:OoefkbD$EHA.3908@.TK2MSFTNGP12.phx.gbl...
> Hello -- does anyone know of any good tools to create queries for SQL
> Server? I'm currently using Query Analzyer, but would like something a
> bit more QUI oriented similar to what Access has -- where I can insert
> tables and drag columns, etc.
> Any help would be appreciated.
>
>|||This one seems nice --
http://www.sqlmanager.net/products/mssql/query
"Hank Arnold" <rasilon@.aol.com> wrote in message
news:351eeqF4fnrjtU1@.individual.net...
> Probably the best (and easiest) one I've seen is Crystal Reports.
> --
> Regards,
> Hank Arnold
> "DavidM" <spam@.spam.net> wrote in message
> news:OoefkbD$EHA.3908@.TK2MSFTNGP12.phx.gbl...
>
Query Builder Tool
Hello -- does anyone know of any good tools to create queries for SQL
Server? I'm currently using Query Analzyer, but would like something a bit
more QUI oriented similar to what Access has -- where I can insert tables
and drag columns, etc.
Any help would be appreciated.
Hello DavidM.
You can use Enterprise Manager for an interface very similar to Access.
Click the tables node to get a listing of all the tables in the right pane.
Select a table and right click. Select open table from the pop up menu.
Select Query. You should now see an interface like Access that you can use to
design queries.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"DavidM" wrote:
> Hello -- does anyone know of any good tools to create queries for SQL
> Server? I'm currently using Query Analzyer, but would like something a bit
> more QUI oriented similar to what Access has -- where I can insert tables
> and drag columns, etc.
> Any help would be appreciated.
>
>
|||Probably the best (and easiest) one I've seen is Crystal Reports.
Regards,
Hank Arnold
"DavidM" <spam@.spam.net> wrote in message
news:OoefkbD$EHA.3908@.TK2MSFTNGP12.phx.gbl...
> Hello -- does anyone know of any good tools to create queries for SQL
> Server? I'm currently using Query Analzyer, but would like something a
> bit more QUI oriented similar to what Access has -- where I can insert
> tables and drag columns, etc.
> Any help would be appreciated.
>
>
|||This one seems nice --
http://www.sqlmanager.net/products/mssql/query
"Hank Arnold" <rasilon@.aol.com> wrote in message
news:351eeqF4fnrjtU1@.individual.net...
> Probably the best (and easiest) one I've seen is Crystal Reports.
> --
> Regards,
> Hank Arnold
> "DavidM" <spam@.spam.net> wrote in message
> news:OoefkbD$EHA.3908@.TK2MSFTNGP12.phx.gbl...
>
Server? I'm currently using Query Analzyer, but would like something a bit
more QUI oriented similar to what Access has -- where I can insert tables
and drag columns, etc.
Any help would be appreciated.
Hello DavidM.
You can use Enterprise Manager for an interface very similar to Access.
Click the tables node to get a listing of all the tables in the right pane.
Select a table and right click. Select open table from the pop up menu.
Select Query. You should now see an interface like Access that you can use to
design queries.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"DavidM" wrote:
> Hello -- does anyone know of any good tools to create queries for SQL
> Server? I'm currently using Query Analzyer, but would like something a bit
> more QUI oriented similar to what Access has -- where I can insert tables
> and drag columns, etc.
> Any help would be appreciated.
>
>
|||Probably the best (and easiest) one I've seen is Crystal Reports.
Regards,
Hank Arnold
"DavidM" <spam@.spam.net> wrote in message
news:OoefkbD$EHA.3908@.TK2MSFTNGP12.phx.gbl...
> Hello -- does anyone know of any good tools to create queries for SQL
> Server? I'm currently using Query Analzyer, but would like something a
> bit more QUI oriented similar to what Access has -- where I can insert
> tables and drag columns, etc.
> Any help would be appreciated.
>
>
|||This one seems nice --
http://www.sqlmanager.net/products/mssql/query
"Hank Arnold" <rasilon@.aol.com> wrote in message
news:351eeqF4fnrjtU1@.individual.net...
> Probably the best (and easiest) one I've seen is Crystal Reports.
> --
> Regards,
> Hank Arnold
> "DavidM" <spam@.spam.net> wrote in message
> news:OoefkbD$EHA.3908@.TK2MSFTNGP12.phx.gbl...
>
Subscribe to:
Posts (Atom)