|
Home > Archive > MS SQL Server OLAP > January 2006 > Simple query hangs!!!!!!!!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Simple query hangs!!!!!!!!
|
|
| Jim_OLAP 2006-01-26, 4:58 pm |
| All,
This query hangs --even though there are only 710,000 records in the table.
select count(*) from pos_raw
DBCC CHECK does not return any errors-
DBCC results for 'POS_Raw'.
There are 710765 rows in 8775 pages for object 'POS_Raw'.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'DSD'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
| |
|
| Have you tried sp_who or sp_who2 to see if anything is blocking it?
Jim_OLAP wrote:
> All,
>
> This query hangs --even though there are only 710,000 records in the table.
>
> select count(*) from pos_raw
>
> DBCC CHECK does not return any errors-
>
> DBCC results for 'POS_Raw'.
>
> There are 710765 rows in 8775 pages for object 'POS_Raw'.
>
> CHECKDB found 0 allocation errors and 0 consistency errors in database 'DSD'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
| |
|
| does adding the nolock helps you?
select count(*) from pos_raw (nolock)
what the index plan says?
does your statistics are updated?
"Jim_OLAP" <JimOLAP@discussions.microsoft.com> wrote in message
news:EA60B8FF-2B77-43B7-AB05- 32B3A3F67BFF@microso
ft.com...
> All,
>
> This query hangs --even though there are only 710,000 records in the
> table.
>
> select count(*) from pos_raw
>
>
> DBCC CHECK does not return any errors-
>
> DBCC results for 'POS_Raw'.
>
> There are 710765 rows in 8775 pages for object 'POS_Raw'.
>
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'DSD'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
>
>
>
>
|
|
|
|
|