Activity overview
Latest activity by jonstahura
I resolved the last issue by deleting the repository and installing the latest update. I deleted the database and had it start fresh.
It worked since the 17th, but now it is back.
I am trying to figure out what is going on.
Right now the query running for 40 minutes is:
<?query --
DELETE [data].[Cluster_Keys]
FROM @Chunk c
INNER JOIN [data].[Cluster_Keys] d WITH (ROWLOCK) ON c.[Id] = d.[Id]
-- FORCE ORDER: The order above is carefully chosen, and this prevents pathological orders.
-- LOOP JOIN: Profiling shows that this tends to improve performance, as long as the number of rows to be deleted is small
-- compared to the number of rows in the table, by encouraging index seeks.
OPTION (FORCE ORDER, LOOP JOIN, MAXDOP 1)
--?> / comments
I resolved the last issue by deleting the repository and installing the latest update. I deleted the database and had it start fresh.
It worked since the 17th, but now it is back.
I am trying to fi...
Clogging up the sql
Does anyone know why this query is killing my instance.
INSERT INTO [#Cluster_SqlServer_Error_Keys]
SELECT [Id]
FROM [data].[Cluster_SqlServer_Error_Keys_Purgeable](@PurgeDate)
I have killed the sp...
no values for database
I had data for a long time on the buffer page life and other sql values... then it just stopped.. everything is 0...
I check the log and it says everytihng is ok... i am getting machine information..
you could script it...
i am using dynamic sql to restore 54 databases in a row. I am restoring to another computer and instance, so it is a little more than what you would typically use.
it is pretty easy..
help instructions: EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [pubs] FROM DISK = ''C:\Backups\pubs_01.sqb'' WITH REPLACE" '
my way:
set @SQL = ' EXECUTE master..sqlbackup ''-SQL "RESTORE DATABASE ' + @sitename +
' FROM DISK = ''''' + @backupfilepath + ''''' WITH MOVE DATAFILES TO ''''' + @dbdirectory + ''''' ,
MOVE LOGFILES TO ''''' + @tlogdirectory +''''' , REPLACE " '' '
exec sp_executesql @sql
/ comments
you could script it...
i am using dynamic sql to restore 54 databases in a row. I am restoring to another computer and instance, so it is a little more than what you would typically use.
it is pret...
i can consistently recreate the issue. If you would like to do a remote or something to see if you can track something down, i would be willing to be a test bunny.
It really creates a wait when opening up alerts. / comments
i can consistently recreate the issue. If you would like to do a remote or something to see if you can track something down, i would be willing to be a test bunny.
It really creates a wait when ope...
i hate to say it.. but ti works...
something must be happening in chrome... [image] .. so depressing... IE is nice and snappy compaired.. i have not had ANY of the wait time that hasbuilt up in chrome. / comments
i hate to say it.. but ti works...
something must be happening in chrome... .. so depressing... IE is nice and snappy compaired.. i have not had ANY of the wait time that hasbuilt up in chrome.
i will test it with IE to see if i have the same results..
i also have been using chrome... i hate using IE.. this is the 3rd application in my company that "FORCES" me to use IE.. grrr
although the commercial song for IE is catchy... lol / comments
i will test it with IE to see if i have the same results..
i also have been using chrome... i hate using IE.. this is the 3rd application in my company that "FORCES" me to use IE.. grrr
although th...
well it is just me.... so i don't see users being an issue.
I was doing some testing.. it seems that if I remote into the monitor server and open a browser to localhost... it is WAY WAY faster...
Everything else seems to run ok... just the alerts take FOREVER.. / comments
well it is just me.... so i don't see users being an issue.
I was doing some testing.. it seems that if I remote into the monitor server and open a browser to localhost... it is WAY WAY faster...
E...
Slowdown of interface
I have 8 servers on my sql monitor.
The response time has slowed down SO much.
When I try to open alerts from the inbox, it takes 30 or more seconds to open.
Is there a reason for this? Can I speed...
thanks for the link.. i figured it out.
I needed more single quotes... a LOT more.... and then it worked! [image] / comments
thanks for the link.. i figured it out.
I needed more single quotes... a LOT more.... and then it worked!