Viewing 15 posts - 23,191 through 23,205 (of 49,552 total)
Depends on the number of rows affected, the amount of locks and lock memory already and probably a few other factors.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2011 at 3:17 am
ahmed_b72 (9/28/2011)
How can I obtain the hostname and login name for each row in dm_exec_query_stats ?
Simple. You don't.
Query stats is just the list of queries that have run in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2011 at 3:16 am
frfernan (9/29/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2011 at 3:10 am
islandwino (9/28/2011)
Absolutely, I know 3rd party backup tool and native has their merits and demerits, I wanna know the specific details. I am newbie to sql backup.
Then you need to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 29, 2011 at 3:07 am
Jack Corbett (9/28/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2011 at 4:26 pm
Grant Fritchey (9/28/2011)
Assuming updates to different partitions, no you shouldn't see blocking while those updates are occurring. You can still block within a partition though.
Though if both cause lock escalation,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2011 at 3:22 pm
Your row estimation is off, right from the beginning.
In the index seek on the far right, estimated rows 1, actual 1000. That's having ripple effects the whole way through....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2011 at 3:18 pm
jgoodier (9/28/2011)
While looking at the "Resource Monitor" I noticed that sqlservr.exe has IO on the pagefile.sys files that I have. Why is this? Shouldn't sqlservr page to its own LDF's?
Errr,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2011 at 2:30 pm
sickpup (9/28/2011)
FWIW, I see that you can do multi-site clustering without the SAN,
Yes, you can, but your inactive node is still inactive. You cannot write to both databases in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2011 at 2:18 pm
sickpup (9/28/2011)
GilaMonster (9/28/2011)
Database mirroring comes to mind. The database on the second server is still unavailable (because it's in the restoring state), the mirroring keeps the two in sync.
Yeah, that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2011 at 1:35 pm
mjbkm (9/28/2011)
GilaMonster (9/28/2011)
EXEC sp_updatestats
Or, maybe better
UPDATE STATISTICS <table name> WITH FULLSCAN
where <table name> is the name of the table that you did all...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2011 at 12:54 pm
Database mirroring comes to mind. The database on the second server is still unavailable (because it's in the restoring state), the mirroring keeps the two in sync.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2011 at 12:45 pm
From a query window (connected to that database)
EXEC sp_updatestats
Or, maybe better
UPDATE STATISTICS <table name> WITH FULLSCAN
where <table name> is the name of the table that you did all those deletes/inserts...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2011 at 12:33 pm
Jack Corbett (9/28/2011)
I'll re-run the process to the point of that operator in SSIS and then run this in SSMS to get the actual plan.
I'll wait for that, because what...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2011 at 12:31 pm
Can you get me the actual plan please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 28, 2011 at 11:42 am
Viewing 15 posts - 23,191 through 23,205 (of 49,552 total)