sqldbadiaries.com
SQL DBA Diaries of Pradeep AdigaSQL DBA Diaries of Pradeep Adiga
http://www.sqldbadiaries.com/
SQL DBA Diaries of Pradeep Adiga
http://www.sqldbadiaries.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Sunday
LOAD TIME
2.1 seconds
Contact Privacy Inc. Customer 0124281084
Contact Privacy Inc. Customer 0124281084
96 M●●●● Ave
To●●to , ON, M6K 3M1
CA
View this contact
Contact Privacy Inc. Customer 0124281084
Contact Privacy Inc. Customer 0124281084
96 M●●●● Ave
To●●to , ON, M6K 3M1
CA
View this contact
Contact Privacy Inc. Customer 0124281084
Contact Privacy Inc. Customer 0124281084
96 M●●●● Ave
To●●to , ON, M6K 3M1
CA
View this contact
BUY YOUR DOMAIN
14
YEARS
9
MONTHS
19
DAYS
TUCOWS DOMAINS INC.
WHOIS : whois.tucows.com
REFERRED : http://domainhelp.opensrs.net
PAGES IN
THIS WEBSITE
20
SSL
EXTERNAL LINKS
28
SITE IP
66.96.132.117
LOAD TIME
2.109 sec
SCORE
6.2
SQL DBA Diaries of Pradeep Adiga | sqldbadiaries.com Reviews
https://sqldbadiaries.com
SQL DBA Diaries of Pradeep Adiga
sqldbadiaries.com
Performance | SQL Server DBA Diaries
http://www.sqldbadiaries.com/category/troubleshoot-2/performance-troubleshoot-2
SQL Server DBA Diaries. Application timing out due to excessive blocking on tempdb PFS. Applications Connecting to SQL Server timing out. Excessive blocking with the wait resource being tempdb PFS page. High CPU utilization on the server. Sysdm exec requests reported blocking and the head blocker looked like this. Session id ecid wait type resource. 58 4 PAGELATCH UP 2:7:32352. 58 0 CXPACKET exchangeEvent id=Pipe7dd014b80. The wait resource was always reported at tempdb PFS page (2:7:(8088*x) . The tempd...
Application timing out due to excessive blocking on tempdb PFS | SQL Server DBA Diaries
http://www.sqldbadiaries.com/2014/09/17/application-timing-out-due-to-excessive-blocking-on-tempdb-pfs
SQL Server DBA Diaries. Application timing out due to excessive blocking on tempdb PFS. Applications Connecting to SQL Server timing out. Excessive blocking with the wait resource being tempdb PFS page. High CPU utilization on the server. Sysdm exec requests reported blocking and the head blocker looked like this. Session id ecid wait type resource. 58 4 PAGELATCH UP 2:7:32352. 58 0 CXPACKET exchangeEvent id=Pipe7dd014b80. The wait resource was always reported at tempdb PFS page (2:7:(8088*x) . The tempd...
Configure | SQL Server DBA Diaries
http://www.sqldbadiaries.com/tag/configure-2
SQL Server DBA Diaries. No transaction is active message when accessing Linked Server. Last week I had worked on an issue related to Linked Server. The customer had migrated the SQL Server Instances to Virtual Servers. They had quite a few Linked Servers setup. After migration any Distributed Transaction like the one below across the linked servers would fail immediately. Select * from RemoteServer.DBName.dbo.TableName. Msg 7391, Level 16, State 2, Line 2. This problem typically occurs if one of the syst...
About | SQL Server DBA Diaries
http://www.sqldbadiaries.com/me
SQL Server DBA Diaries. I am working with the SQL Server support team at Microsoft. I use this blog to post things that I learn or the problems that I resolve and share it with the SQL Server community. I am actively contributing to many online SQL Server DBA communities like MSDN. Pradeep is also one of the editors at SQLServerPedia. To know more about Pradeep, drop in an email to. No transaction is active message when accessing Linked Server. Export the Event Logs without opening MMC.
Replication | SQL Server DBA Diaries
http://www.sqldbadiaries.com/category/replication
SQL Server DBA Diaries. CDC job failing with “Unable to add entries to the Change Data Capture LSN time mapping table to reflect dml changes applied to the tracked tables” error. I got a chance work on CDC job failure issue recently. The customer had configured CDC on the database but it wasn’t working as expected. Hence he had disabled/enabled CDC multiple times on this database. The “cdc.[DBName] capture” job was failing with the following error. Message: 22858, Level 16, State 1. Table On a normal CDC...
TOTAL PAGES IN THIS WEBSITE
20
DBA Scripts | Wisdom-Soup
http://www.wisdom-soup.com/blog/category/dba-scripts
Share SQL Server Tips and Tricks and Related News. Category Archives: DBA Scripts. How to: Verifying CPU Pressure via Signal Wait Time. Use the following query to verify the CPU pressure via signal wait time through MS SQL Server Management Studio. USE master GO SELECT SUM(signal wait time ms) AS TotalSignalWaitTime , ( SUM(CAST(signal wait time ms AS NUMERIC(20, 2) ) / SUM(CAST(wait time ms AS NUMERIC(20, 2) ) * 100 ) AS PercentageSignalWaitsOfTotalTime FROM sys.dm os wait stats. And tagged cpu pressure.
Troubleshooting | Wisdom-Soup
http://www.wisdom-soup.com/blog/category/troubleshooting
Share SQL Server Tips and Tricks and Related News. Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission. While we tried to drop one of our Windows Login from SQL Server, part of our house-keeping task, and SQL Server prevent us from dropping the Windows Login even though we have unmapped all the database mapped and owned by the login. It works fine for us before this. Msg 15173, Level 16, State 1, Line 2. But our SQL Server was not configured with mirroring. This entry was posted in SQ...
SQL Server Security | Wisdom-Soup
http://www.wisdom-soup.com/blog/category/sql-server-security
Share SQL Server Tips and Tricks and Related News. Category Archives: SQL Server Security. Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission. While we tried to drop one of our Windows Login from SQL Server, part of our house-keeping task, and SQL Server prevent us from dropping the Windows Login even though we have unmapped all the database mapped and owned by the login. It works fine for us before this. Msg 15173, Level 16, State 1, Line 2. To obtain the mirroring endpoint name.
Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission | Wisdom-Soup
http://www.wisdom-soup.com/blog/troubleshooting/unable-drop-windows-login-sql-server-due-endpoint-permission
Share SQL Server Tips and Tricks and Related News. Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission. While we tried to drop one of our Windows Login from SQL Server, part of our house-keeping task, and SQL Server prevent us from dropping the Windows Login even though we have unmapped all the database mapped and owned by the login. It works fine for us before this. Msg 15173, Level 16, State 1, Line 2. But our SQL Server was not configured with mirroring. This entry was posted in SQ...
SQL Server Build Version
http://www.wisdom-soup.com/blog/sql-server-version
Share SQL Server Tips and Tricks and Related News. This list is original from SQLTeam.com website. And MS SQL Server Builds. Last updated on 24 July, 2013). You can also find the SQL Server and Updates Builds Numbers. From Microsoft TechNet website. Please visit to this page. On how to determine the version and edition of SQL Server and its components. SQL Server 2012 CU1. SQL Server 2012 RTM. SQL Server 2008 R2. SQL Server 2008 R2 SP1 CU6. SQL Server 2008 R2 SP1 CU5. SQL Server 2008 R2 SP1 CU4. SQL Serv...
2013 year in blogging | DBA By Day, Gamer By Night
https://ndflanagan.wordpress.com/2013/annual-report
DBA By Day, Gamer By Night. Happy New Year from WordPress.com! Each rocket represents a post published on this blog in 2013. And because we like to share, we made the fireworks available as a jQuery plugin on GitHub. Some browsers are better suited for this kind of animation. In our tests, Safari and Chrome worked best. Your overall score is not known. We made beautiful, animated fireworks to celebrate your blogging! A New York City subway train holds 1,200 people. This blog was viewed about 5,900. Samsu...
Data Science | with Pradeep Adiga
http://www.pradeepadiga.me/datascience
Anaconda installation on Windows fails with IOError: [Errno 9] Bad file descriptor. How to find the version of all modules installed in Python. 8220;SSL3 GET SERVER CERTIFICATE:certificate verify failed” error while accessing secure site using PyCurl. Anaconda installation on Windows fails with IOError: [Errno 9] Bad file descriptor. Recently when I was installing Anaconda on Windows, it failed with the following error. Traceback (most recent call last):. File "C: Anaconda2 Lib nsis.py", line 164, in.
Tempdb | Wisdom-Soup
http://www.wisdom-soup.com/blog/tag/tempdb
Share SQL Server Tips and Tricks and Related News. Script to Check TempDB Speed. The following script adopted from Brent Ozar’s blog on his TempDB Performance and Configuration. Topic I strongly encourage you to pay a visit to his site. This query hits the dynamic management function (DMF) sys.dm io virtual file stats for all of the TempDB data files and lists out how fast they’re responding to write (and read) requests:. Are writes being evenly distributed between data files? February 28, 2014. ALTER DA...
Dmv | Wisdom-Soup
http://www.wisdom-soup.com/blog/tag/dmv
Share SQL Server Tips and Tricks and Related News. How to: Verifying CPU Pressure via Signal Wait Time. Use the following query to verify the CPU pressure via signal wait time through MS SQL Server Management Studio. USE master GO SELECT SUM(signal wait time ms) AS TotalSignalWaitTime , ( SUM(CAST(signal wait time ms AS NUMERIC(20, 2) ) / SUM(CAST(wait time ms AS NUMERIC(20, 2) ) * 100 ) AS PercentageSignalWaitsOfTotalTime FROM sys.dm os wait stats. Detect SQL Server CPU Pressure. And tagged cpu pressure.
TOTAL LINKS TO THIS WEBSITE
28
Aaron Mathison's SQL Server Blog | Writing about SQL Server related topics
Aaron Mathison's SQL Server Blog. Writing about SQL Server related topics. Productivity Tip: ClipX Clipboard History Manager. April 18, 2011. This post was written originally for my personal blog, but I decided to re-post it here since it is a different audience and the tip is probably more useful to the more technical readers I hope to have here. Enjoy! The other day I was at work and I realized how much time this tiny little application called ClipX. As helpful as I do! SQLSaturday 71 – Boston. Among o...
SQL DBAcademy | .Net and SQL training – Developers and DBAs
Net and SQL training – Developers and DBAs. Selecting data from large set. July 13, 2015. So once again I was given the task of optimizing a proc. After going through my check list , the proc was still not behaving . As a last resort I was inclining towards adding indexes but then my eyes fell on one of the books on rack – ART of SQL. Bingo! I should try rewriting the proc. Learnings : Decide whether you want to INCLUDE data or EXCLUDE data – which one would require less efforts. June 11, 2015. Now If yo...
SQL DBA Chronicles
Help, Hints and Tips learnt along the way as a SQL DBA. Monday, 18 May 2015. WSS Logging Sharepoint Database Size Reduction. Has your Sharepoint WSS Logging database grown massive. See the links below on how to shrink the size of the WSS Logging database. Https:/ guidesharepoint.wordpress.com/2014/03/03/how-to-reduce-the-size-of-logging-database-and-how-to-purge-the-old-data-from-logging-database/. If you need to shrink the database after you have changed the Sharepoint retention settings:. Simple templa...
sqldbacvstockholm.wordpress.com
Word Of The Day | We said: "Get ye down all from here; and if, as is sure, there comes to you Guidance from me, whosoever follows My guidance, on them shall be no fear, nor shall they grieve.
Word Of The Day. We said: Get ye down all from here; and if, as is sure, there comes to you Guidance from me, whosoever follows My guidance, on them shall be no fear, nor shall they grieve. BI – SSRS. BI – SSIS. Cloud based AlwaysOn AG. Microsoft Azure, you need the following:. A virtual network setup in Azure. A storage account setup. A Microsoft Azure domain controller. One or more Microsoft Azure Virtual Machines with SQL Server 2014 installed and configured for AlwaysOn Availability Group. A SQL Serv...
SQL DBA Diaries of Pradeep Adiga
SQL Server DBA Diaries. No transaction is active message when accessing Linked Server. Last week I had worked on an issue related to Linked Server. The customer had migrated the SQL Server Instances to Virtual Servers. They had quite a few Linked Servers setup. After migration any Distributed Transaction like the one below across the linked servers would fail immediately. Select * from RemoteServer.DBName.dbo.TableName. Msg 7391, Level 16, State 2, Line 2. This problem typically occurs if one of the syst...
SQL DB Administrator - Home
Project Hosting for Open Source Software. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). Web based administrator for SQL Server 2005. Last edited Nov 27, 2009 at 6:17 PM. Opera does not support ClickOnce X. To install this application, save it and then open it. Opening it directly from Opera will not work correctly. SQL DB Administrator Release 1.0. Tue Mar 4, 2014 at 7:00 AM. Version 8.4.2015.21029.
404 Not Found
The requested URL was not found on this server. Apache/2.0.50-dev (Unix) Server at 199.244.53.205 Port 80.
SQLDBAgeeks
Thursday, June 11, 2015. Troubleshooting MS SQL 2005 Mirroring. Principal: Backup database FULL recovery. Mirror: restore database with NORecovery mode. Mirror : restore all transaction logs. Principal : Right click database and click mirroring. Principal : add Principal DNS name and Mirror DNS name. Principal: click start mirroring. NDPOINT: Mirroring TO public. Turn off Windows firewall (normal port is 5022). Delete endpoints (the end points are on both Principal and Mirror). Tuesday, March 4, 2014.
Home Page
MS SQL Server 2008 R2 features. How to change the default port in MS SQL server - . Am I seeing double - Find duplicates in a sql tabl. Upgrade service pack on a MS SQL 2000 cluster. Take advantage of over 4 GBs memory in MS Sql ser. Recovering from corrupt master (system) in MS SQL . Learn to kill blocks in MS SQL Server 2000. Find your IP address. Find you MS SQL server version. HOW to run an MS SQL trace. The new version on SQL 2008 has many new useful features. SQl server is better than Mysql.
My Site
This is my site description. Powered by InstantPage® from GoDaddy.com. Want one?
SOCIAL ENGAGEMENT