Viewing 15 posts - 871 through 885 (of 1,079 total)
You are running SQL Server 2005?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2010 at 2:42 am
If possible, add about 3 runs of IO stats as well...the more info you provide, the quicker and better assistance we can give.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2010 at 2:33 am
I would suggest you look into it, as you are queries ID rows, which I would assume is Unique, and I would assume the ID column has a primary key?
Adding...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2010 at 1:54 am
I see what you mean.
do you have indexes on those 2 tables?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2010 at 1:26 am
downloads a "test.zip" and contains xml's?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2010 at 1:09 am
Np, pleasure.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2010 at 1:05 am
If I recreate the jobs meant for replication, will it be affected??
Yes, but DONT recreate the jobs, simply modify the existing schedules, by changing the time, and changing it back...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2010 at 12:39 am
These might help...
http://www.sql-server-performance.com/articles/dba/object_permission_scripts_p1.aspx
and a quick one for per-instance-check:
USE master;
SELECT *
FROM fn_my_permissions(NULL, 'SERVER');
GO
and another for per DB check:
USE master;
SELECT *
FROM fn_my_permissions('master', 'DATABASE');
GO
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2010 at 12:37 am
create a new simple job with a quick t-sql query, schedule it for 5 minutes ahead of now, check if it runs at the exact time.
If it does, I'd say,...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2010 at 12:24 am
before starting the job, run the following:
DBCC sqlperf(logspace)
after starting the SSIS job, execute it again, every 10 seconds, and see if there is a significant change in the size of...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2010 at 12:19 am
run
select GETDATE() and confirm you're SQL server returns the exact same date and time as you're Windows Server.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2010 at 12:15 am
I meant you're system TEMPDB, not the custom temp table..
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2010 at 12:12 am
interesting...
by how much does you tempdb and log grow during this process?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 19, 2010 at 12:06 am
As a test, add a TOP 2270 in you're select statement, see if it works?
If you confirm that you're data is in fact healty and normal, it's a bit strange...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 11:56 pm
If you have installed just the SSMS Basic Tools (such as from Express Advanced, or by not selecting SSMS advanced during setup), you will not be able to use Job...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 18, 2010 at 11:47 pm
Viewing 15 posts - 871 through 885 (of 1,079 total)