Skip to main content

Posts

Showing posts from August, 2018

Full Text search in MongoDB

Full text search is similar to content search from entire database or from storage where data is located. It is something similar to how we search any content in any search application by entering certain string keywords or phrases and getting back the relevant results sorted by their ranking. This is common requirement in any large data-set application for quick and efficient searching method.

This post I am sharing about text search from MongoDB database. Text search option is available in almost every database either RDBMS family or NoSQL family.  Mongodb have something different that is ranking (weight of attributes). Starting from version 2.4, MongoDB began with an experimental feature supporting Full-Text Search using Text Indexes. This feature has now become an integral part of the product. The Text Search uses streaming techniques to look for specified words in the string fields by dropping stop words like a, an, the, etc. 

What are the features of  "Mongodb Full Text Searc…

SQL Servers 20 steps after start or re-start

This was always in my mind, what happened when we start or restart sql server services from os service panel. There are long list of activities process out to get connected with database. These are below :
1. Server process ID allocation and with Authentication mode.
2. Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQL2012\MSSQL\Log\ERRORLOG'.
3. Registry startup parameters setting for master, error,log -d,-e, -l
4. SQL Server detected cpu and cores and allocating as per licenses and configuration .
5. SQL Server is starting at normal priority base (=7). 
6. SQL Server Detecting RAM and allocating to server as per awe and configured. 
7. SQL Server Detecting Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0 for NUMA configuration.
8. Starting up database 'master' and do transactions rolled forward in database 'master' (1:0).
9. SQL Server Audit is starting the audits. 
10. SQL Trace ID 1 …

Database Performance Troubleshooting Methodologies and Dimensions

When You have assigned a task to optimize a database or performance tuning of an application. Then there could be various dimensions to perform this task because slow performance of application could be many more which can not describe on single page but it can be summary in a table like below I found this table that shows database performance and slow running application performance dimension and there activity start procedures.

Performance Dimensions Percentage Values Process Strength Activity StrengthRemarksApplication Design and Business process 25.00% Long Process Lower priority Module wise activity.Database Schema Design - Logical 15.00% Medium Follow best practices Required short downtime Module wise activity.Database Maintenance 15.00%Quick processRequired on OLTPShort downtime weekly or monthly.Indexing 15.00% Quick processRequired on OLTPShort downtime weekly or monthly Module wise activity.Server Hardware (CPU/Memory/other) 12.00% Medium process Follow best practices Long …